INDEXING IN mysql when using multiple columns

Asked Nov 15 '21 at 12:16

Active Nov 15 '21 at 12:16

Viewed 51 times

In my project I am using DataTables plugin to display data in table from database.

Every column has filter so user can filter data based on input on each column.

I am confused how to setup indexes, do ever column need index?

Is it good practice to index every column in table?

My table have 6 columns.

asked Nov 15 '21 at 12:16

NikolaSae

2

https://stackoverflow.com/questions/29842622/why-and-where-to-use-indexes-pros-and-cons – Ergest Basha Nov 15 '21 at 13:02
Sanity check: In your DataTable, are you using `serverSide: true`? – andrewJames Nov 15 '21 at 13:19
1

Does this answer your question? [Why and where to use INDEXes - pros and cons](https://stackoverflow.com/questions/29842622/why-and-where-to-use-indexes-pros-and-cons) – Ghost Ops Nov 17 '21 at 13:17

0 Answers0