Select the order of tenant_id inside an index
221
Views
0
Comments
New
Database

Hi,

It would be great if when create and index of a table we can chose the order of tenant_id column.

Depends of the volumen of the data, the information (columns) and the filters you need, the order of the column inside the index it´ s high important. Sometimes, the better approach it´´  s put tenant_id in first place and we don´ t have this option (or we don´ t found).

If we can select the order, performance is greatly improved

Regards.