Analyze trade offs of having indexes for lft and rgt columns
|Category:||Data model / ORM|
|Google Code Legacy ID:||Tested version:||2.6|
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.