If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by
Read More...