[dba-SQLServer] Temp Tables

As with all tech questions. It depends


Largely in the quantity that you dump over to the temp table, how much
space is available on disk for the tempdb how fast the i/o is for the
tempdb




On 6/30/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...