Hi Gurus

If a full table scan causes a query to time out or crash what can I do
to investigate and resolve. Note: the query runs fine if the where
clause causing the full table scan is commented out.

Ideas greatly appreciated.

Cheers
David

------------------------------
Combined Services SFL
Thus Plc Demon.net
i : 740 4153
e : 0141 273 4153
m : 07801 452918


Oracle LazyDBA home page