[dba-SQLServer] Temp Tables

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 




More information about the dba-SQLServer mailing list