Oh I should have guessed from the schema name about the restrictions. I know
it doesn't help much but they will let you rewrite the SQL but won't let you
hint the statement?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Andy" <enzoweb_at_hotmail.com> wrote in message
news:8d4033cd.0201300221.4951dc22_at_posting.google.com...
> Welcome to the Wonderful World of Siebel.
>
> I used a FIRST_ROWS hint and got the time down from 4 mins 51 secs to 5
secs.
>
> However, Siebel won't let us use hints. Or Cost based optimizer. Or
Partitioning.
>
> I'll put the explain plan output here, but trust me, it's doing a full
table scan.
>
> Feel free to copy and paste it and run explain plan on it.
>
> "Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message
news:<oSH58.158649$_w.24645083_at_typhoon.tampabay.rr.com>...
> > God, that query was ugly.
> >
> > Tom
> > www.oraclepower.com
> >
Received on Wed Jan 30 2002 - 04:44:42 CST
