Re: Performance with temporary table

We store traffic data in the partitioned tables. But the problem is
that all this data is not correct. The data is corrupt, hence they
need to be corrected.

On Wed, Apr 9, 2008 at 10:31 PM, Erik Jones <erik@myemma.com> wrote:
>
>  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(R)
>  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
>
>
>
>