mysql query going for full table scan -


update apa_pended_demand apd inner join apa_generic_demand_details agd     on agd.demandid = apd.demandid  set apd.genericdemandid = agd.genericdemandid apd.ispend = 1 ,       agd.genericdemandid != '' ,       agd.genericdemandid not null ,       apd.reactivatedate > utc_timestamp() ,       agd.status < 300 ,       apd.id between 280001 , 290000 ; 

the above query going full table scan.so can please me in sorting query


Comments

Popular posts from this blog

qt - QML MouseArea onWheel event not working properly when inside QML Scrollview -

java - is not an enclosing class / new Intent Cannot Resolve Constructor -

python - Error importing VideoFileClip from moviepy : AttributeError: 'PermissionError' object has no attribute 'message' -