how do i optimize indexes on tables in a DataMart sql database
We use an ETL sofware from (SAP) and we use Buisness Objects (reporting software)
Our DM (DataMart) is giving poor respons ( i am told).
1. How do i get hold of the Queries (sql statments) from the ETL software and BO
(Reporting Software) which runs on the DM. ( 2 tables i am told)
2. Once i get hold of the SQL than i can optimise the indexes.(which i need help too?)