On Index Optimizations in DBDetective 2.0 for Oracle

DBDetective for Oracle is a metadata mining tool for detecting possible violations of some crucial database (db) design, Oracle implementation, usage, and optimization best practice rules (bprs); its 1.0 version considers eight bprs related to indexes and already allows storing corresponding decision data for six of them: as, for example, investigated db current instances may not be typical for all tables, db architects might not validate DBDetective findings and/or even force db scheme changing although DBDetective did not recommend them.

Provided by: Scientific Online Publishing (SOP) Topic: Data Management Date Added: Sep 2014 Format: PDF

Find By Topic