In my installation of ECC 6.0 with sap basis 17 and kernel 7.0 patch level 186, in transaction dbacockpit we have a lot of "SQE Indexes Advised" and if we order them by "Times Advised" in 15 of the 20 first positions we found tables DD*.
is it correctly?
In the instance profile the parameter dbs/db4/nqe_optimize_method is not active. should be it active?
The database access is slow but the sap process response quickly.
What can we analize?
Thanks in advanced.