On Sun, Jun 19, 2022 at 12:06 PM Дмитрий Иванов <firstdis...@gmail.com> wrote:
> Good afternoon. > I have a query parser question. If there are two kinds of queries using an > indexed field. In this case, one view is limited to this field, the second > one uses a number of fields included in the index by the include directive. > It makes sense to have two indexes, lightweight and containing include. Or > will the plan rely on the nearest suitable index without considering its > weight? > > The system should avoid the larger sized index unless it will sufficiently benefit from the Index Only Scan that such a larger covering index is supposed to facilitate. David J.
