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 |
|
Lopaka
Starting Member
48 Posts |
 Posted - 2009-03-18 : 18:15:09
|
| I have a table that values get inserted from several website... It currently has an index on the date field and source code, (from website). My question is, "Is there a special index used on real-time data?". If so, can you explaine or point me to website that does?Using SQL2005 and SQL2005...Robert R. Barnes |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-03-18 : 20:15:19
|
| There is no "special index used on real-time data". What are you trying to accomplish with your index?Jim |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-19 : 11:18:33
|
| the choice of index depends on what queries would be fired against the table more frequently and columns they target upon for searching. please note that simply making an index on table doesnt guarantee it will be used. |
|
|
|
|
|
|
index