Index Creation....
-
Hi ,
Can some one please help me out here. I have a table with 60Million rows in it. The tables is broken up into 4 datafiles with in the same file group. I am trying to build the index(clustered) for the table and place the index in another datafile with in another file group. However on completion of the index it seems that all the data has been moved to the same datafile and file group as the index...can someone please shead some light on this for me.
Thanks
Dazed and confused right now....
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
That is what it is supposed to do. !!
clusterd as discribed in BOL :
CLUSTERED
Creates an object where the physical order of rows is the same as the indexed order of the rows, and the bottom (leaf) level of the clustered index contains the actual data rows. ...
maybe this helps :
http://www.sqlservercentral.com/columnists/lPeysakhovich/indexcreationguidelines.asp
http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp
http://www.sqlservercentral.com/columnists/rgummadi/indexingstrategies.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply