November 11, 2008 at 8:03 am
Hi i have very big table in rows more than 100 million and also many check and forien key constraints
planning to create non clustered index, what is the best practice to do it on existing table.
what should be keep in mind
November 11, 2008 at 8:36 am
It will take time and you'll need disk space to house the index. It will require resources, so you might want to pick a low activity period to do it in.
Is there something else you are concerned about?
November 11, 2008 at 8:38 am
Users are having performance problems recently.
I have planned it do at off hours .
it makes any problem while creating it because table has
Many forien key relations.
November 11, 2008 at 9:47 am
shree (11/11/2008)
Users are having performance problems recently.I have planned it do at off hours .
it makes any problem while creating it because table has
Many forien key relations.
No problems. Number of foreign keys is immaterial when creating indexes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2008 at 10:35 am
Do make use of ONLINE option while creating the index.
MJ
November 11, 2008 at 10:53 am
do you have example script for creating online index.
i know i can find it on books online but still...,
November 11, 2008 at 11:05 am
CREATE INDEX idx_1 ON table1(col1) ONLINE
MJ
November 11, 2008 at 11:31 am
Thank you very much, i realized my database was sql2000 version
i cannot use of it.
Thank you.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply