Global Temporary Table - Erratic results?

I posted a question last week where people where some of the guys who replied recommanded that I use "create global temporary table" instead of "create table". I tried it with the script I've been asked to modify that contained the latter construction.

I get my results every time with the "create table" version, but if I'm lucky, I get results maybe 50% of the time with the "create global temporary table". Take note that it's the same queries that are run in both cases and that I also tried the "on commit delete rows", "on commit preserve rows" clause, and that the tables are dropped at the end. Why does it do this?

Are tables created with "global temporary" different that regular tables?

Thanks

Denis Received on Mon Aug 21 2006 - 15:03:47 CDT