Issue with Global temporary table

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Thu, 31 Jan 2002 11:30:28 -0800
Message-ID: <F001.004027D0.20020131110522@fatcity.com>

Hi,
We have 3 tables involved a query. If all the tables are permanent then we have a
explain plan with very less cost and query runs very fast BUT if we use 1 global temporary table..explain plan is different with high cost...and it seems
it don't use index for other tables also........... Is this drawback with Global Temporary Tables........... Thanks
--Harvinder Received on Thu Jan 31 2002 - 13:30:28 CST