Jaise James
Reputable Poster
Hello
We are on E810 /nt/sql server Have auditing turned on a few tables.
I was running a report R9698713 to recreate inddexes if they are mising. I tried it in proof mode and it came back saying the indexes are missing on the table which have audting enabled
Now I know that is not correct and it probably was checking againt the view instead of actual ADT table.
Given this, Does any one know if the you have the auditing enabled, will the queries from e1 use the correct indexes as it does not recognise the corect indexes.
I am little confused and concenred.
Any insight into this will help
We are on E810 /nt/sql server Have auditing turned on a few tables.
I was running a report R9698713 to recreate inddexes if they are mising. I tried it in proof mode and it came back saying the indexes are missing on the table which have audting enabled
Now I know that is not correct and it probably was checking againt the view instead of actual ADT table.
Given this, Does any one know if the you have the auditing enabled, will the queries from e1 use the correct indexes as it does not recognise the corect indexes.
I am little confused and concenred.
Any insight into this will help