title: Choosing Index on table
body: <p>My table have 10 columns but i will use 5 columns more frequent.
  which is the better way to create an index 
  like do we have to create index in all the 5 columns or composite index do we have to create.
  Actually performance is main thing to consider
  i don't have much idea in tuning side.</p>