but these would have no affect if Siebel has optimizer mode set to RULE, no?

"Geomancer" <pharfromhome@hotmail.com> wrote in message
news:cf90fb89.0311081511.7e5b142c@posting.google.c om...
> > I'm trying to figure out what might have slowed down considerably
> a specific query these past days.
>
> If Siebel uses RBO then it is most-likely a partially analysed schema.
>
> Look for "accidental" stats on any table, and remove them:
>
> select table_name from dba_tables where num_rows > 1;