QUERY PLAN DETERMINATION

摘要

In one example in accordance with the present disclosure, a method for determining query plans includes obtaining a current query and generating a first literal and a first signature key from the current query. The method includes determining that the first signature key matches a second signature key stored in a parser cache and obtaining a literals data structure corresponding to the second signature key. The literals data structure comprises a group of literals, a list of high and low boundary intervals and a parameterization indicator. The method includes identifying, using the parameterization indicator, a parameterized literal in the group of literals. The method includes determining that a high and low boundary interval for the second parameterized literal contains the first literal and executing a stored query plan on the current query.

主权项

1. A method for determining query plans, the method comprising:
obtaining a current query; generating a first literal and a first signature key from the current query; determining that the first signature key matches a second signature key stored in a parser cache; obtaining a literals data structure corresponding to the second signature key, the literals data structure comprising a group of literals, a list of high and low boundary intervals and a parameterization indicator; identifying, using the parameterization indicator, a parameterized literal in the group of literals; determining that a high and low boundary interval for the second parameterized literal contains the first literal; and executing a stored query plan on the current query.