Re: indexes reserve too much extents

On Mon, 03 May 2004 16:26:03 GMT, john <john_at_catylist.com> wrote:

>With the indexes enabled, SQL Loader builds indexes while imporing data,
>each index leaflet occupies a data block, that is why the usage of index
>space swell.
>If you turn off the index in SQL Loader by set indexes=n, then rebuild
>index afterwards, you will get much smaller index space.
>
>
>John

Sorry to say so
Where did you learn this utter rubbish?
Since when does 'each leaflet occupy a data block'. Any documentation to support this statement?
Since when does sqlloader have an 'indexes=n' clause?

--
Sybrand Bakker, Senior Oracle DBA