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 <adambrusselb...@gmail.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? >
