On 09/18/2013 12:20 PM, Shaun Thomas wrote:
On 09/18/2013 11:05 AM, "Gabriel E. Sánchez Martínez" wrote:
Or would it have to check every child partition, as follows?
#
Check partition 2000-01-01, 2000-01-02, ... , 2013-09-18. 5010 checks.
All days but 2012-01-01 are excluded. 5009 partition
On 09/18/2013 11:05 AM, "Gabriel E. Sánchez Martínez" wrote:
Or would it have to check every child partition, as follows?
#
Check partition 2000-01-01, 2000-01-02, ... , 2013-09-18. 5010 checks.
All days but 2012-01-01 are excluded. 5009 partitions excluded with
5010 constraint exclusion chec
On 09/18/2013 11:34 AM, Shaun Thomas wrote:
On 09/18/2013 07:45 AM, "Gabriel E. Sánchez Martínez" wrote:
Now to the questions. Would constraint exclusion work in a tree
fashion to prune tables from a query plan?
Constraint exclusion works by checking the constraints themselves. So
if your
On 09/18/2013 07:45 AM, "Gabriel E. Sánchez Martínez" wrote:
Now to the questions. Would constraint exclusion work in a tree
fashion to prune tables from a query plan?
Constraint exclusion works by checking the constraints themselves. So if
your constraints are based on date, they will alway
