Re: Performance Tuning ?

Cost based works on the last results of "anaylze tables" and rule based works on a set of 15 rules. Where you are analyzing your tables you may use cost based, alternatively use rule based. Ashok.

Norman Neil wrote:
>
> Check out O'Reilly & Associates website for the book Oracle Performance
> Tuning , 2e (www.ora.com). It's a great reference! Your library would
> probably have it. I'd give you the ISBN but my copy is lent out! :(
>
> Hope that helps....
>
> Norm
>
> Andrew Locke wrote in message <01bd53a9$e4d22e40$319275c2_at_albr01036>...
> >My name is Andy and I am currently doing an assignment in university with
> >regards to Oracle performance tuning.
> >
> >Could anybody (please) point me towards some documents on :-
> >
> >1> The effects of adding an index to a table.
> >2> The differences between cost and rule based optimisation.
> >
> >n.b. I am using Oracle 7.1.3 (I believe)
Received on Sat Apr 04 1998 - 00:00:00 CEST