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 |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2001-09-26 : 14:34:14
|
| I'm working on an application that pulls several rescordsets from a linked Oracle server into SQL temp tables, does some other processing, and spits out the results in an asp page. For efficient processing, I should create some indexes on a couple of fields.The recordset pulls are in the range of 100 - 2000 records each. Is there a difference in performance between creating the index in the CREATE TABLE statement or using an ALTER TABLE statement after the import? |
|
|
zhm
Starting Member
1 Post |
Posted - 2003-01-13 : 20:47:00
|
| sssssssssssss |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-14 : 07:22:19
|
| If I were you, I'd try both ways and capture metrics.Jay White{0} |
|
|
|
|
|
|
Which is faster - create indexes on insert or afte