Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Atif
Starting Member
9 Posts |
 Posted - 2007-01-11 : 02:40:01
|
| I created two tables one is based on partition structure and one is non-partition structure.File Groups= Jan,Feb.....DecPartition 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. |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Unable to get the performance with Partition table