Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2008-11-18 : 09:55:15
|
Hi,Is there any way we can create indexes faster?I have a table with around 50 million rows(90 cols)..and for testing purpose, we need to create index and drop it off.It takes around 30 mins for the index to get created. I know its a really weird question, but now its only 9 mins since the create index has been fired..Its really annoying to wait for 30 mins  Is there any way we can create a sample index (with only part of the data), and just get the estimated plan for the query?ThanksSam |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-18 : 10:49:08
|
| Not until SQL 2008. In SQL 2008 you can create filtered indexes over a subset of table data.http://msdn.microsoft.com/en-us/library/ms188783.aspx |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-11-18 : 10:57:06
|
| What is your real objective? To improve the speed of the index creation or to test a query with the new index? If you want to test a query with the new index without causing any trouble to your production database I'd suggest you create a new database with a backup and try the index there. If you want to speed up index creation the only option I can think of at the moment is to partition your table first and place the partition files on different disks...but I get the feeling this is not what you're asking for.- Lumbago |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-11-18 : 10:58:46
|
| On the other hand...a 50mill row table with 90 columns would probably be a good candidate for partitioning...- Lumbago |
|
|
|
|
|
|
Create index..