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 |
|
pankaj.malhotra
Starting Member
5 Posts |
 Posted - 2009-02-05 : 07:29:20
|
| I have created partition on table on states basis.Lets say data of every state store in different partition of one table. Now when i am writing a query and that query is using data of 4 data of 4 states , will it use partition and result data more fast. Or i have to retrieve data from one state only to use partition.Is there any specific thing i have to write to use partition.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-05 : 07:31:06
|
| Yes it definitely will if you have followed the rules of partitioning. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-05 : 07:36:54
|
| also just in case you want to improve query speed, you can create indexes on individual partitions also |
|
|
|
pankaj.malhotra
Starting Member
5 Posts |
Posted - 2009-02-05 : 23:01:01
|
| What you exactly mean by rules of partitioning? and url for same ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 08:56:02
|
quote:
Originally posted by pankaj.malhotra
What you exactly mean by rules of partitioning? and url for same ?
Means When you follow rules for which partition is designe for like:1)Separate Filegroups according to Partition Key to Separate Disks to take advantages of PARALLEL THREADS.2)Align the Partition Index with the regular Index.3)Moving Read-only Partition to Read-only FG with Switch in/out. |
|
|
|
abcd
Yak Posting Veteran
92 Posts |
Posted - 2009-02-06 : 23:42:39
|
| hi sodeep......i was going through ur reply....can you explain how to execute parallel threads using partitioning...i know how partition is done using file groups and key...jst wanat to discuss this topic more...thanks in advance........ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-07 : 09:22:56
|
quote:
Originally posted by abcd
hi sodeep......i was going through ur reply....can you explain how to execute parallel threads using partitioning...i know how partition is done using file groups and key...jst wanat to discuss this topic more...thanks in advance........
When Multiple FG are spread accross Mulitple Drives, Queries take advantage of PARALLEL THREADS. There is very Good Whitepaper on Table Partitioning .Search for it and post if you have any issues with it. |
|
|
|
|
|
|
Partition