Marco +1. I'll also use them in a version upgrade, where the schema is changing and I am converting tables to the new schema, I may need to store an old key in a table in order to use it to also convert the data in detail tables below the current one. In that case I'll create a temp (working) index on that old key, then drop the index and column at the end of the patch. Performance is vastly improved in the conversion.