Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Advantages/disadvantages of having tables within 'SYSTEM' TS
"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
news:aQFMa.6$eD3.174_at_news.oracle.com...
> > I have a hard time believing this. AFAIK Oracle has *no* method for
> > disabling access paths on a tablespace basis. If you can demonstrate
this
> > I'd be more convinced. Generally the SYSTEM and SYS *schemas* aren't
> > analyzed so some access paths won't be considered as the RBO is used,
this
> > is not the same as disabling them for a tablespace.
>
> You may verify it in 9.2:
>
> select --+ INDEX_SS(o i_OBJ2)
> * from sys.obj$ o where name = 'EMP'
>
> (hint would trigger CBO).
Actually you are right, that's a schema decision, not tablespace one. Received on Wed Jul 02 2003 - 14:54:55 CDT