In this SQL Optimizer for SAP ASE video, we demonstrate how to use the Index Usage Analyzer to determine which indexes are not being used.
Related Articles
Can multiple application PDBs be updated in a single DML?
Introduction Oracle documentation states that it is possible to update a metadata linked table in multiple Application PDBs in a single DML statement. Here are some excerpts with relevant parts highli...
Oracle DBMS_JOB Overview
The DBMS_JOB package is actually an API into an Oracle subsystem known as the job queue. The Oracle job queue allows for the scheduling and execution of PL/SQL routines (jobs) at predefined times and/...
Oracle 18c Autonomous Health Framework (AHF) – Part 1
Recently I had to present at eProseed AnualTech conference in Luxembourg and I was requested to present a topic something about Oracle18c. Obviously I don't want to talk and repeat the same about Aut...
