• yes, i can use Create Index with Drop existing and it is working fine.

    But I still dont understand what is wrong with the former statement.