TheMadScientist - 7:43 pm on Mar 24, 2011 (gmt 0)

Thanks, been a long time since I've read all that stuff and it's filed away somewhere, so I only remember bits and pieces at times ... I always index anything I will be selecting by as habit, and really don't understand why people wouldn't? I guess at times you'll hit an index max size, but for the most part, imo, if you're using it in the 'where' you should find any way to index it ... Am I missing something?