• Why not?

    I don't know, i have no experience of implementing indexing till now. What i have read from online articles, its important to index the columns which comes in where condition.

    if i have 5 columns to retrieve in my queries then what's the best way of indexing ?