Re: Performance with temporary table

On Apr 9, 2008, at 6:41 PM, samantha mahindrakar wrote:
> Hi
> The reason for using the temporary table is that i need this data
> buffered somewhere so that i can use it for later computation. And the
> fact that for each imputation i need to have historical data from 10
> previous weeks makes it necessary to create something that can hold
> the data. However once the computation is done for each record i
> wouldn't need that historical data for that record. I Would be moving
> on to the next record and find its own historical data.
> Is there any way i can avoid using temp table?

What's wrong with the data in the paritions?

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com