From: Jerry Gitomer <jgitomer@erols.com>
Subject: Re: index inital extent
Date: 2000/08/08
Message-ID: <20000808.4422300@mis.configured.host>#1/1
Content-Transfer-Encoding: quoted-printable
References: <8mni7p$pi4$1@netnews.upenn.edu>
X-Priority: 3 (Normal)
Content-Type: text/plain; charsetISO-8859-1
X-Complaints-To: abuse@rcn.com
X-Trace: vrrXwCcxv5hjotPAWZHZAHygg69MXu0pT6+p/K+dsIM
Mime-Version: 1.0
NNTP-Posting-Date: 8 Aug 2000 03:36:27 GMT
Newsgroups: comp.databases.oracle.misc



	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@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@seas.upenn.edu