Re: [PERFORM] Performance with temporary table

[Decibel!]

On Apr 8, 2008, at 2:43 PM, Alvaro Herrera wrote:

samantha mahindrakar escribió:

Well instead of creating a temp table everytime i just created a

I created indexes on this permanent table too. This did improve the
performance to some extent.

permanant table and insert the data into it everytime and truncate it. Does using permanant tables also bloat the catalog or hinder the performance?

In terms of catalog usage, permanent tables behave exactly the same as
temp tables.

--
Decibel!, aka Jim C. Nasby, Database Architect  [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828

True, but the point is that you're not bloating the catalogs with thousands of temp table entries. I agree with others though: it certainly doesn't sound like there's any reason to be using temp tables here at all. This sounds like a case of trying to apply procedural programming techniques to a database instead of using set theory (which generally doesn't work well).

smime.p7s
Description: S/MIME cryptographic signature