Home » RDBMS Server » Performance Tuning » Query optimize (oracle, 10.2.0.2, AIX5.3)
Query optimize [message #556265] Fri, 01 June 2012 05:37 Go to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Hi Leaders,

Please help me in the below scenario. I want to optimize the below query as using not equal ( != ) will reduce the performance.
select e1.rowid from emp e1, emp e2 
where e1.attrib in (7, 10)
and e1.attrib != e2.attrib 
and e1.type = e2.type 
and e1.status = 0) 
Re: Query optimize [message #556266 is a reply to message #556265] Fri, 01 June 2012 05:39 Go to previous messageGo to next message
soft_doctor
Messages: 33
Registered: May 2010
Member
Requesting you to please suggest as it is bit urgent!!!!
Re: Query optimize [message #556278 is a reply to message #556266] Fri, 01 June 2012 06:15 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing is urgent on forum but YOU to follow OraFAQ Forum Guide and post what is requested.

Please do it, it is urgent!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Regards
Michel
Previous Topic: Verify statspack
Next Topic: Why delete a where rowid=:1 go to index?
Goto Forum:
  


Current Time: Fri Mar 29 04:57:52 CDT 2024