I have a table with an index whose name is _WA_Sys_MVndNbr_12A9974E. When I try to drop the index, I get the message that the index does not exist in system catalog. However, the index does exist in sysindexes.
Failing to drop the first index, I created a second index on the same column called Test_MVndNbr.
My questions are:
1)How do I drop the index _WA_Sys_MVndNbr_12A9974E?
2)How do I use my second index Test_MVndNbr? If I write a query which references the column on which Test_MVndNbr was created, is Test_MVndNbr used automatically by SQL?