RE: Index Rebuilds

Hi cyril,

   Yes, Analyzing a table is one of the simplest solution to such problems.

   I had implemented Analyzing Tables fro some performance reasons, and result was just Amazzzzzzing. Although the Optimizer mode is RULE/CHOOSE/COST at instance level, if you analyze a table, you get the performance benefits for all the queries relating to that table.(In some cases I have got performance gain from 1000 sec to 2-3 sec). Again from my experience, bigger the table size better the result you can expect after analyzing the tables.   And yes you can (and should) analyze the tables while the tables are in use, there is no concept of downtime for this operation.
  Please give your feedback after analyzing....

HTH,
Rajesh

-----Original Message-----

cyril wrote:

> Hello!
>
> I am 'really surprised' that the solution 'commonly' provided for
'such
> problems' is analyze the table..
>
> Do people really analyze tables? ( I mean do u get so much down time!
if
> not how do u manage it!)
> Do people really run their applications in COST BASED mode...
> cos our organisation has been using Oracle6 onwards and since then
the
> applications have been tuned
> for rule based and recently we tried to move to COST BASED and since
all
> the programs gave a huge problem
> we cried off...
>
> Has anyone gone from RULE BASED to COST BASED.. can u help!
>
> --
> Author: cyril
> INET: cyril_at_stockholding.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: Joseph S. Testa
  INET: teci_at_oracle-dba.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).