search

cockroachdb / cockroach

CockroachDB - the open source, cloud-native distributed SQL database.
https://www.cockroachlabs.com
Other
29.58k stars 3.71k forks source link

sql: plan foreign key cascade in the optimizer #46674

Closed awoods187 closed 3 years ago

awoods187 commented 4 years ago

Foreign Key Cascades are the last major piece of FKs not planned in the optimizer. We will add them to the optimizer which will improve stability, performance, and allow for us to remove the additional index currently present on foreign keys.

RaduBerinde commented 3 years ago

This has been done for a while (on master).