This discussion is archived
4 Replies Latest reply: May 23, 2013 11:13 AM by 972355 RSS

storage clause for index

972355 Newbie
Currently Being Moderated
Hello to all ;
storage clause for index
- Storage parameters for table ok. I need to know storage clause parameters for index ?

- what is the need for storage parameters for index.
  • 1. Re: storage clause for index
    P.Forstmann Guru
    Currently Being Moderated
    Please read storage clause description in SQL Reference http://docs.oracle.com/cd/E11882_01/server.112/e26088/clauses009.htm.

    It also says:

    >
    Note:
    The specification of storage parameters for objects in locally managed tablespaces is supported for backward compatibility. If you are using locally managed tablespaces, then you can omit these storage parameter when creating objects in those tablespaces.
    >

    Edited by: P. Forstmann on 23 mai 2013 19:55
  • 2. Re: storage clause for index
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Hello to all ;
    storage clause for index
    - Storage parameters for table ok. I need to know storage clause parameters for index ?

    - what is the need for storage parameters for index.
    Just accept default values from the tablespace.
  • 3. Re: storage clause for index
    ji li Pro
    Currently Being Moderated
    Unless you need to specify something other than default, you do not need a storage clause.

    Below is an example of an index storage clause on 11.2, (plus the tablespace since our indexes are in a separate tablespace).
    CREATE INDEX myschema.mytable_col1_IDX ON myschema.mytable
    (col1)
    LOGGING
    TABLESPACE myschema_IDX
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
               )
    NOPARALLEL;
  • 4. Re: storage clause for index
    972355 Newbie
    Currently Being Moderated
    My thanks to all three replies .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points