What is the execution plan of a query is showing? Check whether it is
reading through all partitions.
Best Regards,
*Sushant Pawar | Database Solution Consultant*
*ASHNIK TECHNOLOGY SOLUTIONS PVT. LTD.*
Skype: sush_531 | T: +91 9769559995 <%2B65%206438%203504> | www.ashnik.com
On Tue, Feb 21, 2017 at 4:47 AM, Adam Brusselback <adambrusselback(at)gmail(dot)com
> 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?
>