Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unlimited extents
Hi,
I don't think the number of extents an index or table CAN have, has an
influence on your performance.
It's the number of extents that the index or table REALLY HAS that
influences the performance :
the more extents you have, the more the performance will decrease.
I don't care about a few extents, but a table or index with 100 extents
doesn't sound like an optimized database ;-)
regards,
Thierry Poels Thierry.Poels_at_vab.be
Oracle DBA & Unix System Manager for VTB-VAB
Gocha Mchedlishvili wrote in message ...
>I was told that if I create index with unlimited extents option, it will
>decrease performance of database.
>Is it true?
>
>thanks
>
>Gocha
>
>
Received on Mon Nov 23 1998 - 04:10:13 CST