I have used /*+leading(vcs)*/ in the query . Then also it's taking same time as before. is there any other way to resolve this issue?
Thank u
Type: Posts; User: srlsrao; Keyword(s):
I have used /*+leading(vcs)*/ in the query . Then also it's taking same time as before. is there any other way to resolve this issue?
Thank u
Hi I am getting result from this query. there is no errors in the query. But it is getting result from View and 3 tables. So it's taking 45 mins to retrieve the data.So i need to tune this query...
sql query tuning
Hi , I am using Oracle 9.0.4.0.
my issue i have a quey as follows. it's taking 45 mins time. Please help me to increase the performance.I have done Explain Plan and stats.But still I am getting the...