Re: About Index ?

From: Mark Malakanov <markmal_at_home.com>
Date: Thu, 19 Apr 2001 11:49:47 GMT
Message-ID: <vhAD6.52111$5E3.16114937_at_news3.rdc1.on.home.com>


Oracle does not have limit on size of index. Optimizer decides to use or not to use index depending on many factors, statistics of table/index, initialization parameters, session settings, etc...

--
-----------------------------------------------------
Thanks,
Mark

"Vukadinov Branislav" <Branislav.Vukadinov_at_ev.co.yu> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:9bm72m$tmm$1_at_Mercury.ev.co.yu...

> Hi, all
>
> I would like know does Oracle have limit on size index.
> Actually, does Oracle use index under some limit ( number of rows ) and
> after that aproach sequentially ?
>
> Thanks
>
> branislav.vukadinov_at_ev.co.yu
>
>
>
Received on Thu Apr 19 2001 - 13:49:47 CEST

Original text of this message