jwcolby
jwcolby at colbyconsulting.com
Sat Jun 30 08:28:02 CDT 2007
It just occurred to me that perhaps I need to be working with temp tables more. I have queries against 65 million record tables with WHERE clauses with anywhere from 4 to 20 fields. If I broke my queries against my huge tables into base query that pulled a data set into a temp table based on one of those fields, and then ran the remainder of my where clause against the smaller temp table I think I might get a speed bump. Any thoughts on that? John W. Colby Colby Consulting www.ColbyConsulting.com