Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: index inital extent

Re: index inital extent

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/08/08
Message-ID: <20000808.4422300@mis.configured.host>#1/1

        No. In fact at one client site they were using an ERP system which in more than one case had compound indexes consisting of all of the columns in the table. The indexes were bigger than the tables.         

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 8/7/00, 6:54:33 PM, samuels_at_red.seas.upenn.edu (Maurice Samuels) wrote regarding index inital extent:

> can anyone tell me is there any reason to have the initial extent of
 an index be greater than the initial
> extent of the table to which the index is on? are there any reasons to
 

be concerned if the index's initial
> extent is greater?
> thanks in advance
> -maurice
> samuels_at_seas.upenn.edu
Received on Tue Aug 08 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US