Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    83

    Lightbulb Unanswered: TaBLESPACE in sql server

    I have the below quey in Oracle, Please suggest me the equivalent for the same in SAL Server .

    I came to know that the equivalent for tablespace in SQL Server is filegroup, but i dont know the equivalents for the other parameters used,

    CREATE INDEX index_1 ON temptab(colnam)
    TABLESPACE DATA
    PCTFREE 15
    INITRANS 1
    MAXTRANS 25
    STORAGE (
    INITIAL 18K
    NEXT 28K
    MINEXTENTS 1
    MAXEXTENTS 117
    PCTINCREASE 30
    FREELISTS 1
    FREELIST GROUPS 1
    BUFFER_POOL DEFAULT
    )

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Have you even tried looking up "CREATE INDEX" in BOL?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Oracle Tablespace <=> SQL Server FileGroup

  4. #4
    Join Date
    Oct 2006
    Posts
    83
    Thank u,

    What is the equivalent for storage parameters in that query

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    There are no storage parameters. In SQL Server storage is system managed. The closest you will find to PCTFree/PCTUsed is FillFactor, but that is only used forindex creation, and rebuilding. It has no effect on the block level storage beyond those two actions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •