4 Replies Latest reply: May 23, 2013 1:13 PM by 972355 RSS

    storage clause for index

    972355
      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
          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
            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
              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
                My thanks to all three replies .