Adding index through SQL

[gb]

Hello,

We have a very big table (close to 20 mil records now) and would like to add a new index there. Doing it through Axapta will take longer then if we would do it through SQL directly. Our operation is 24X7.

Plan:
1. create that index on the table in a test environment, export the table.
2. create that index on that table directly in SQL on production environment ( using same naming convention)
3. import the project into Production environment.

We hoped that Axapta will recognize that the index is already there and won't recreate it. Unfortunately, it didn't recoginze it and recreated it.

Question. Is there a way to register that index with Axapta somehow, like for example, SQLDictionary table where all fields are saved? Is it possbile at all?

I would appreciate any comments.
Thanks,
gb