Add keyspace option in DROP INDEX statement.