This is apparently supported by Enterprise edition, but not by Standard
edition.
I've had a look at BOL, but am none the wiser. What does this mean exactly?
Does it mean that I can't get the standard edition to run two or more create
index commands at the same time? If so, what would happen if I attempted to
do that? Would all but the first get ignored or would SQLServer simply
queue them to run them sequentially?
Thanks
GriffThey're referring to using multiple CPU's to build the same index.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Griff" <Howling@.The.Moon> wrote in message
news:Oc49pdjfEHA.4092@.TK2MSFTNGP10.phx.gbl...
This is apparently supported by Enterprise edition, but not by Standard
edition.
I've had a look at BOL, but am none the wiser. What does this mean exactly?
Does it mean that I can't get the standard edition to run two or more create
index commands at the same time? If so, what would happen if I attempted to
do that? Would all but the first get ignored or would SQLServer simply
queue them to run them sequentially?
Thanks
Griff
Tuesday, March 20, 2012
Parallel CREATE INDEX
Labels:
apparently,
bol,
create,
database,
edition,
enterprise,
index,
microsoft,
mysql,
oracle,
parallel,
server,
sql,
standardedition,
wiser
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment