Task #13359

Analyze trade offs of having indexes for lft and rgt columns

Added by José Raddaoui Marín over 1 year ago.

Status:NewStart date:06/15/2020
Priority:MediumDue date:
Assignee:-% Done:


Category:Data model / ORM
Target version:-
Google Code Legacy ID: Tested version:2.6
Sponsored:No Requires documentation:


We recently added a DB index for the information_object rgt column, which adds to the one we had for the lft column. While we move out from a nested set implementation (if we do), with the inclusion of CTE in MySQL 8, we should consider the trade offs of such indexes.

Also available in: Atom PDF