-
Stats Collection - Performance degradation
I have an observation i collected the statistics on index & table but query responding slow , now when i tried to run query after deletion it gave result with in second. Why this happening?
-
Hi,
Could u post more details abt total rows and no of deleted rows?
-
Tablesize : 531 M
Rows : 35,35,676
Indexes Sizes varies between 70M ~ 150M.
I rebuild all the indexes and result is same.
how i will find the deleted rows.
Last edited by navisd; 10-20-2006 at 03:25 AM.
-
because the statistics you gathered werent good enough, and the RBO was just using indexes as it should
-
Originally Posted by davey23uk
because the statistics you gathered werent good enough, and the RBO was just using indexes as it should
Will
optimizer_mode=CHOOSE Help in this regard?
-
what do you have it set to at the moment
-
Mode of optimizer is set to CHOOSE
and version of oracle is 8.1.7.0
-
well changing it from CHOOSE to CHOOSE wont help much
you need to work out what stats are requried for your data
how do uyou generate them?
-
Post the explain plans with and without statistics on the table, as well as the query.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|