Indexes are used to fasten access to the record in Oracle. Optimizer chooses an index over a full table scan based on the Index Statistics. The statistics allow the optimizer to calculate the effectiveness of using one index over another. Let’s check out how to find the index statistics How to check Index statistics for […]

The post How to check Index statistics in Oracle appeared first on Techgoeasy.