• Thank you both!

    I know that usage of hints should be avoided as much as possible. My thoughts were if in case the stats got out of date the option with the index hint is better.

    Finally I managed to reconstruct a scenario when the stats are not updated and the query optimizer got to use the newly created index again regardless of the outdated stats.

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com