Database Tuning (MOSC)

MOSC Banner

about select performance

edited Dec 17, 2010 3:59PM in Database Tuning (MOSC) 6 commentsAnswered
1.our system have a daily report table(produce every day ,have a index in it ) ,  we analyse the table staticts in every night (after 22:00) .

so the next day ,the query's performance will be better,

2.sometime , we will need query the dialy table in the same day afternoon,sometime   we will find  the query  select the table performance will be worse , because it do a  full scan (db file scattered read ), but  after a while , the same

query will be better , use  index rang scan (db file sequential read), so in this situation , if we want avoid the  worse  query plan, how we should do ? use hint ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center