A query which runs fine and fetches around 30k records in 15 seconds. If I create a Temp table using "On commit preserve row" using that query, takes more time(15 mins)
Any idea why this would happen?
It's always the same reason:
The table is created as a SET table plus a bad Primary Index (usually no PI defined, so defaulting to first column)