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 |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2009-01-21 : 00:38:13
|
| I have table with columnsperson_id GUIDfirst_name VARCHAR(100)last_name VARCHAR(100)stree VARCHAR(100)city VARCHAR(50)passport_no VARCHAR(50)table ll contain trillions of rows, and i fear that it ll become very slow bcos i know that indexing on VARCHAR columns is not that effecient.WHAT SHOULD BE THE BEST SENARIOS TO OPTIMIZE MY SEARCH QUERIES ON VARCHAR DATA WITH SUCH A HUGE QUANTITY. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-21 : 01:27:48
|
Trillions of records?We are 7 billion people on earth...
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-01-21 : 01:54:57
|
| thats not a answer of my question... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 08:29:58
|
| Consider doing Table Partitioning(if Ent Edition) for better performances. |
|
|
|
|
|
|
Query Optimization