All are saying that if we keep INDEX for columns, it will increase the performance.
Suppose take one table having 5 columns. For our application we will use all columns for searching. (Means column1 like '%xyz%' or column2 like '%xyz%'......)
So, for this we need to give for all columns INDEX to improve performance right:D?
Ofcourse primary key itself having index, so we need to keep 4.
please reply for the above doubt.