Skip to content

DBA Index Columns

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

DBA Index Columns

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DBA Index Columns.sql
DBA Index Columns.sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title DBA Index Columns | Oracle EBS SQL Report
description – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Index, Columns, dba_indexes, dba_ind_columns, dba_objects
permalink /DBA%20Index%20Columns/

DBA Index Columns – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

None

Report Parameters

Table Name starts with

Oracle EBS Tables Used

dba_indexes, dba_ind_columns, dba_objects

Report Categories

Enginatics

Related Reports

DBA Segments, DBA ORDS Configuration Validation, DBA Result Cache Objects and Dependencies, DBA AWR Active Session History, DBA Blitz Report ORDS Configuration, DBA SGA Active Session History, DBA Dependencies (uses)

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA Index Columns 22-Dec-2025 084146.xlsx
Blitz Report™ XML Import DBA_Index_Columns.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-index-columns/

Executive Summary

The DBA Index Columns report provides a detailed view of database indexes, specifically focusing on the column order. The order of columns in a composite index is critical for performance: an index on (A, B) is very different from an index on (B, A). This report helps DBAs and developers verify that indexes support their query patterns.

Business Challenge

  • Query Tuning: "I have an index on (STATUS, CREATION_DATE), but the query on CREATION_DATE is still doing a full table scan. Why?" (Because STATUS is the leading column).
  • Redundancy Check: "Do we have duplicate indexes? (e.g., one on A and another on (A, B))".
  • Design Verification: "Did the migration tool preserve the correct column ordering?"

Solution

This report joins DBA_INDEXES with DBA_IND_COLUMNS.

Key Features:

  • Column Position: Shows the exact order of columns (1, 2, 3...).
  • Uniqueness: Indicates if the index enforces a unique constraint.
  • Function-Based Indexes: Shows the expression used (e.g., UPPER(USER_NAME)).

Architecture

The report queries DBA_INDEXES and DBA_IND_COLUMNS.

Key Tables:

  • DBA_INDEXES: Index header information.
  • DBA_IND_COLUMNS: Column details.

Impact

  • Performance Optimization: Ensuring the "leading column" matches the query predicates is the #1 rule of indexing.
  • Storage Savings: Identifying and dropping redundant indexes saves disk space and reduces overhead on INSERT/UPDATE.
  • Schema Integrity: Verifies that unique constraints are properly backed by indexes.

Useful Links

© 2026 Enginatics