Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: chained rows
HI -
Be careful !!!
If you only analyze some tables, the joined queries with some analyzed and some non-analyzed tables/views may slow down tremendously, depending on the parameter OPTIMIZER_MODE in your init.ora file. It mainly slows down for rule based optimizer, but apparently works great for COB or cost based optimizer.
I would suggest either you analyze all the tables or none at all. There is
package
dbms_utility.analyze_schema to analyze all tables in a schema.
Suresh Bhat
Oracleguru
www.oracleguru.net
oraclefuru_at_mailcity.com
farrellyr_at_my-deja.com wrote in article <7ltrcu$pe8$1_at_nnrp1.deja.com>...
> I want to start checking for chained rows. I have run the utlchain.sql
> to set up table for information. What I am wondering is, do I have to
> go through and analyze table 'table_name' list chained rows for every
> table? Or is there a way I can narrow it down to a certain number of
> tables? Like maybe finding the most used or something like that, if so
> how would I go about that?
>
> Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Wed Jul 07 1999 - 11:12:53 CDT