On Index Optimizations in DBDetective 2.0 for Oracle

Download Now
Provided by: Scientific Online Publishing (SOP)
Topic: Data Management
Format: PDF
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.
Download Now

Find By Topic