[MDEV-18413] Find constraint correlated indexes Created: 2019-01-29 Updated: 2020-11-11 Resolved: 2019-03-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Fix Version/s: | 10.4.3 |
| Type: | Task | Priority: | Minor |
| Reporter: | Galina Shalygina (Inactive) | Assignee: | Galina Shalygina (Inactive) |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Description |
|
This task concern constraints on one table only. Two indexes i1 and i2 are called constraint correlated if some of their parts are contained in the same constraint. For example: Index i1: on lineitem(l_shipdate) And let's add constraint c on lineitem: l_shipdate < l_receiptdate As i1 l_shipdate and i2 l_receiptdate both participate in c, indexes i1 and i2 are constraint correlated. |