title: Single column/multiple column index, what is better?
body: <p>I have one poor performing procedure with couple of queries in it.</p>
  
  <p>I have identified few temp table queries that does scanning of temp table. I decided to add index on temp table to avoid table scanning. I have noticed that there are multiple columns of temp table which are being used in where clause. However, I am not sure whether I should include all columns in single index (composite index) or multiple indexes with one column each index to gain the maximum performance.</p>
  
  <p>Database is DB2</p>