Re: Query huge table vs additional caching table
An index(startdate,notifyflag,deleteflag) will likely perform well if most hits are near one another, eg recent startdates. Otherwise with many millions of rows and the low selectivity of two-value columns for notify & delete, it might be a drag esp. if you are polling it every minute---in that case you might want a caching table.
Subject
Written By
Posted
September 28, 2018 01:27AM
Re: Query huge table vs additional caching table
September 28, 2018 11:02AM
September 29, 2018 01:21PM
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.