Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    69

    Unanswered: Regaring File groups

    I am currently converting some Oracle scripts to SQL Server. Encountered this following code segment in a CREATE TABLE query :

    CONSTRAINT ck_PK PRIMARY KEY ( O_ID) USING INDEX TABLESPACE DIRECT PCTFREE 10 STORAGE ( INITIAL 65536)) TABLESPACE DIRECT PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1)

    what is the equivalent conversion in SQL Server. Is it just ON PRIMARY in the PRIMARY KEY clause ?? Are the Segments and Extents in Oracle equivalent to Filegroups in SQL Server.

    Appreciate your help

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    In this case, I would say yes. But Filegroup in SQL is actually more often compared to Tablespace. In larger databases, DBA can separate not only the index onto a different filegroup, but also a number of tables in a totally different filegroup. For more information, you can check 'SQL Server Performance Guide for Data Warehousing' in Microsoft.com.

Posting Permissions

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