CODEWITHSUNDEEP
oracle-databaseindexing
HJW
HJW

Reputation: 23443

Difference between USER_INDEXES and USER_IND_COLUMNS

What would be the difference between using USER_INDEXES and USER_IND_COLUMNS in retrieving indexing information?

Upvotes: 1

Views: 3516

Answers (2)

Tony Andrews
Tony Andrews

Reputation: 132600

One describes the index itself, and the other describes the columns in that index. You need both to get the full picture.

Upvotes: 5

Adam Musch
Adam Musch

Reputation: 13583

USER_INDEXES is information about the index itself;

USER_IND_COLUMNS is information about the columns (or expressions) that the index consists of.

Upvotes: 3

Related Questions