Has anyone used index tuning wizard with OEM´s Tuning pack? How´s his recommendation, any use at all?
I ran one today just to test the utility and it started to recommending me to add bitmap indexes in an OLTP database, isnt this crazy?
Also there is some strange thing, I have one PK formed by one column only then another index in another column, the wizard actually is recommending me to drop PK´s index and the other index and create a composite index with these 2... I am puzzled
Has anyone got any good experience with Inex Tuning Wizard?