Hi all!
I have to improvise the performance of this qry since it is running for 15 min. I tried filtering out at the table level instead of where condition.Stats have been collected.For all tables, upi is Rowid. Secondary index wizard does not suggest an index if I create a wrkload with this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.