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:41:18
|
| 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. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-11 : 04:19:15
|
| Sounds like it is just a problem with the estimated plan if the queries run as you expect.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Unable to get the performace with partition table