Optimization- Check the set of conditionals on a WHERE clause against CHECK constraints.
Hello hackers,
I was searching for project ideas and found this
1.Optimization- Check the set of conditionals on a WHERE clause against
CHECK constraints on the table being queried and remove any conditionals
which *must* be true due to the CHECK constraints.
Is it expensive for simple queries?
will it optimize general queries ?
Any thoughts will be helpful.
Thanks.
Shubham Barai <shubhambaraiss@gmail.com> writes:
I was searching for project ideas and found this
1.Optimization- Check the set of conditionals on a WHERE clause against
CHECK constraints on the table being queried and remove any conditionals
which *must* be true due to the CHECK constraints.
Is it expensive for simple queries?
will it optimize general queries ?
TBH, it sounds like it would almost always be a waste of planning cycles.
I doubt that typical applications would issue many queries in which such
an optimization would apply.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers