November 14, 2008 at 7:21 am
How long does it take to Create an Index on a int field (not null) that has 13 million rows in it. There might be couple of hundred duplicates so I think Non Clustered Index would do..
Can I create a Foreign Key on this field to relate to a primary key of another table..Please suggest..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 14, 2008 at 7:37 am
The title name should have been 'Time to Create Index'...I guess that was a typo..:P
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 14, 2008 at 8:30 am
Ahh..looks as it I just wasted a topic. I am done with the Indexing, took like 30 seconds only..Thanks anyways!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 14, 2008 at 8:38 am
Heh... no, not a waste. In fact, thank you very much! I now know how long it takes to create an index on an INT column that has 13 million rows and I got that information without me having to write a test. Thank YOU for taking the time to post your results! 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply