Patrice,
Oracle's response is a bit different to my recent experiences with
first_rows.
When we had our database set to first_rows, I discovered that queries
against data dictionary tables (eg all_objects, all_synonyms) are given
different execution plans if you are in first_rows vs in choose.
I don't see any references to generating statistics on SYSTEM tables.
Why did you bring it up?
As I asked Patrice in my earlier response, have statistics been generated
recently from the RAU?
If not, they should be, as designer is notorious for poor performance
with stale stats. The good perf
This is not outdated -- the Oracle queries against the data dictionary
tables are tuned for RULE and so analyzing the SYS tables wreaks havoc
in the database.
--- Amar Kumar Padhi <[EMAIL PROTECTED]> wrote:
> My information on this may be a bit outdated. I had read it somewhere
> that
> statisti
Title: RE: FIRST_ROWS and the data dictionary
My information on this may be a bit outdated. I had read it somewhere that statistics are not to be generated for SYS tables. Oracle will handle the dictionary information access, irrespective of the optimizer mode being used. The setting of the
Have you recently generated stats from RAU?
Jared
"Boivin, Patrice