The Query Optimizer(the optimizer) The query optimizer is built-in database software. The query optimizer attempts to generate the most efficient execution plan for a SQL statement. The query optimizer considers many factors related to the objects referenced and the conditions specified in the query. This determination is an Read more…
Tuning of the database is very challenging work for the DBA. For this DBA should use Proactive strategy for the database. In Proactive strategy dba should work on few things when they are creating database. We know that for database creation parameter file is required which contains parameters & its Read more…
Tuning of the database is very challenging work for the DBA. These days client wants everything should be fast on the database. It is possible if DBA will use Proactive strategy for the database. For Proactive strategy, DBA should work on a few things when they are creating a database. Read more…