April 9, 2008 at 9:41 am
If a table is partitoned on FieldA, and a query is using FieldB=x and doesn't have FieldA in the query, im guessing SQL has to check all the partitons, is that right?
Can an index be created in such a way to help it out?
Thanks.
April 15, 2008 at 10:02 am
correct, that query must be posted to [worker in] each partition [whether local or federated]
you can+should have secondary indexes for each partition [hopefully the same on each!] which will help each worker find your results quickest
obviously you need to choose an appropriate column as discriminator for the partitioning. perhaps similar to choice of the Clustered Index as foundation, since everything else is built on top of it [eg non-clustered indexes].
also possible to have dedicated server/db for certain queries, eg London, USA, Asia and have these just concentrate on that region (and still be partitioned by TradeDate), perhaps fed by replication
worth doing the requirements [today and for 5-year plan!] to get it right [expensive to change later]
- think Architecture !
HTH
Dick
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply