Home » RDBMS Server » Performance Tuning » SQL Taking ForEver
SQL Taking ForEver [message #65201] Tue, 08 June 2004 13:28 Go to next message
Venkat
Messages: 110
Registered: February 2001
Senior Member
While executing a report(Based on a VIEW), I given Parameter value which is not in the matching in DB, So It should return No Data but the query is Hanging(Running), What might be reason ?

This is an Urgent Assignment...Feel free to contact me @ venkat405@yahoo.com

 
Re: SQL Taking ForEver [message #65207 is a reply to message #65201] Mon, 14 June 2004 03:12 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
depends~.
May be , you need a little tuning.
Is there any indeces an base table?
is it been utilized by your query?
post your execution plan.
Previous Topic: Oracle - Info Log
Next Topic: Regarding Query Tuning
Goto Forum:
  


Current Time: Wed Feb 21 19:54:50 CST 2024