Deep Data Mining Blog: Find Out Oracle Table Columns That Are Indexed

Showing posts with label Find Out Oracle Table Columns That Are Indexed. Show all posts

Monday, December 17, 2018

I use the following query to find out columns that are indexed for a table.

select index_name, column_name from USER_IND_COLUMNS where table_name='MYTABLE'

10 Most Influential People	Text Files and Oracle DB	Predictive Model vs Rule	Build Predictive Model	About Predictive Model Variable	Logistic Regression
Recency Frequency Monetary Analysis	Unique Identifier in Oracle	Materialized View	Database Link	Calculate Percentage Using SQL	Handle NULL Value
Calculate Cumulative Perentage	Find Score Cutoff Value	Remove Duplicates	Calculate Correlation Coefficients	Oracle vs SQL Server	Random Sampling
Table Insert	Read Only Table	Clustering	Ranking	Find Most Frequent	Median Value
Oracle Source Code	Debug PL/SQL	Hide PL/SQL Scripts	Repair Views	Dump Schema	Move Big Files to Amazon