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

Home -> Community -> Usenet -> c.d.o.server -> Re: size of index

Re: size of index

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 22 Jun 1999 08:12:09 GMT
Message-ID: <7knggp$7ac$2@adis.cesnet.cz> 





There is some index structure overhead, and you should compute about pctfree parameter in
storage clause in index creation. Remember in Varchar2 datatype oracle does not store
predefined length but only  used space. It means that index is posible to be shorter.



                        Starous
Received on Tue Jun 22 1999 - 03:12:09 CDT












Original text of this message













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