I am unable to get the performance with table partition RRS feed

  • Question

  • I created two tables one is based on partition structure and one is non-partition structure.

    File Groups= Jan,Feb.....Dec
    Partition Functions='20060101','20060201'......'20061201'
    I am using RIGHT Range in Partition function.
    Then I defined partition scheme on partition function.

    I have more than 7,00,000 data in my database.
    I checked filegroups and count rows. It works fine.

    But When I check the estimation plan time out for query it is same for both partition table and non partition table.

    Thursday, January 11, 2007 8:21 AM