3 ms·
So, you're saying given queries like: select * from t where t.col = 'foo' select * from t where t.col = 'bar' select * from t where t.col = 'baz' Oracle sho
by msluyter 17y ago
So, you're saying given queries like:
select * from t where t.col = 'foo'
select * from t where t.col = 'bar'
select * from t where t.col = 'baz'
Oracle should infer that foo|bar|baz should be parameterized? Interesting idea, though this seems like matter of matching parse trees, and I believe that's a relatively expensive operation, roughly polynomial time, iirc.
- ntoshev 17y agoYou don't have to infer all semantically equivalent queries, comparing queries as linear streams of tokens should do.