Have Sybase IQ msg log which suggests us to add Index in lot of columns.
1. Is it compulsory to create Index on all those mentioned Columns or that needs to be analysed further?
2. What Impact it will give interms of size.Will it consume more space if we create all those Indexes on suggested columns?