I have the same query, and same instance. one is on Development and one is on production.

For some reason, the query was running very fast on development. On the production instance, the query ran very slow and it maxed out my temp tablespace even I set it to 4G, the data never come back

what could be the reason and How can I attack this problems???