|
WJHamel
Aged Yak Warrior
USA
614 Posts |
 Posted - 07/18/2012 : 19:41:01
|
So i have this HUGE data conversion that i'm working on. My scripts are replete with Inner Joins. Overall, many of the joins are taking hours to run. Most of the columns it's reading from have in excess of 200,000 rows, some as many as 700,000. I've indexed as many of those columns as i've had time to at this point, but it's pretty clear that i need to index many more of these columns from these tables.
Is there ANY quicker way to create indexes for ALL columns in a given table without writing code for EACH line? Maybe a 3rd party app that will look at those columns and create an index with a default name? |
|
Building indexes
