Home Forums SQL Server 2005 SQL Server Newbies Partitioned Table and Index Storage Confusion RE: Partitioned Table and Index Storage Confusion

  • January 20, 2014 at 7:45 am

    #1681551

    GilaMonster (1/19/2014)

    Depends. If you create the index on the partition scheme, it will be partitioned like the table and stored across the three filegroups. If you create the index on a filegroup, it's not partitioned and is stored entirely in that filegroup.

    Basically, it's stored where ever the ON clause of the create index specifies.

    Thanks Gila.

    If I don't specify an on clause, will it by default be stored on the primary filegroup?

    IE:

    CREATE NONCLUSTERED INDEX idx_orderdate SalesOrderDetail(order_date)