Hi

Has anyone used index tuning wizard with OEMs Tuning pack? Hows 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 PKs 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?