Post reply

Fact Table Partitioning

  • October 12, 2009 at 5:40 am

    #215437

    Hi Folks,

    Can any one let me know the best way to partition the fact table in SQL Server 2008?

    Currently we have Fact table created on one disk drive which is DataDisk2 and Indexes for the fact table created on IndexDrive2. We wanted to implement the partition for this table and I have decided to partition it while recreating the clustered index key.

    My question here is can I create the fileGroups and datafiles in IndexDrive2 Disk for clustered index. If I create them in IndexDrive2, how the table data in DataDisk2 is handled?

    also we are planning to archive the data so will the above partition method will help archiving?

  • October 14, 2009 at 3:47 am

    #1065556

    Hi

    When u create a cluster index, the table data are in the index (THE CLUSTER INDEX IS THE TABLE). So if u create cluster index on indexDrive , table data will be saved in indexDrive.

    With a non cluster index u can choose a different filegroup.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply