Re: Sub Query is Very Slow
Posted by: Rick James ()
Date: December 05, 2011 11:44PM
Add an index:
create table tmp ( INDEX(cont) ) -- here select cont from temp_tag where heading is null or heading='' or publishdate<>'2011-10-20' or type<>'story' or cont=0;
|Sub Query is Very Slow||Asad ahmed||12/02/2011 11:33PM|
|Re: Sub Query is Very Slow||Peter Brawley||12/03/2011 01:38PM|
|Re: Sub Query is Very Slow||Asad ahmed||12/04/2011 10:52PM|
|Re: Sub Query is Very Slow||Peter Brawley||12/05/2011 02:30AM|
|Re: Sub Query is Very Slow||Asad ahmed||12/05/2011 03:15AM|
|Re: Sub Query is Very Slow||Rick James||12/05/2011 11:44PM|
|Re: Sub Query is Very Slow||Rick James||12/05/2011 11:48PM|
|Re: Sub Query is Very Slow||Asad ahmed||12/06/2011 02:13AM|
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.