What is the execution plan of a query is showing? Check whether it is reading through all partitions.
Sushant Pawar | Database Solution Consultant
ASHNIK TECHNOLOGY SOLUTIONS PVT. LTD.
Skype: sush_531 | T: +91 9769559995 | www.ashnik.com
On Tue, Feb 21, 2017 at 4:47 AM, Adam Brusselback <adambrusselback@xxxxxxxxx> wrote:
Do you have non overlapping check constraints on the partitions by date to allow the planner to exclude the child tables from needing to be looked at?
