For Tables within OMW, have a button for generate DML for tables or indexes. This would launch notepad or copy the DML into the clipboard so that the indexes could be generated with parallelism. Now that would be a cool thing!
I hate it when I have to turn logging on, generate a table in an alternate data source, just so I can extract the CREATE INDEX / CREATE TABLE statements from the logs…
This is also important, because there is some sort of assumption that I can just press “generate indexes” in OMW on a table with 40 million rows.
Another STUPID thing is that the index name assigned to the index in the database is nothing to do with what you see in TDA. Just plain stupid. There should be an identifier in TDA which tells us what name is going to be assigned to the index in the DB for manual reconciliation.
No comments:
Post a Comment