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>
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...Received on Thu Apr 19 2001 - 13:49:47 CEST
> 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
>
>
>