Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: altering table to make it "organized index"
Niall Litchfield wrote:
>
> Two things.
>
> 1. Are you sure that the full table scan is bad. How many blocks does the
> data in the table fit into. If it is relatively few then a FTS may be better
> anyway. Assuming that you are running Oracle 8.05 or above then the cost
> based optimiser is *generally* pretty efficient. (CUE host of replies
> telling me how wrong I am).
>
> 2. You appear to be suffering from a misunderstanding of what 'organisation
> index' means. This statement creates an Index Organised table. This is a
> different fish altogether to a table and an index.
>
> 3. OK so I can't count... If you really must have indexes used alter the
> optimser to the rule based optimiser. (or delete all your statistics)
>
> HTH
I've been in the 7.3 world up to now so haven't had an opportunity to learn
about 8 yet. What is an "index organized table"?
Received on Tue Apr 18 2000 - 00:00:00 CDT