@tabinx

This script will sho all indexes for a table.   SQL> @tabinx HZ_CUST_ACCT_SITES_ALL TableName - Unique - IndexName -IndexPos - ColumnName ----------------------------------------------------------------------------------------------- AR.HZ_CUST_ACCT_SITES_ALL - U - AR.HZ_CUST_ACCT_SITES_U1 - 1 - CUST_ACCT_SITE_ID AR.HZ_CUST_ACCT_SITES_ALL - U - AR.HZ_CUST_ACCT_SITES_U2 - 1 - ORIG_SYSTEM_REFERENCE AR.HZ_CUST_ACCT_SITES_ALL - U - AR.HZ_CUST_ACCT_SITES_U2 - 2 - ORG_ID AR.HZ_CUST_ACCT_SITES_ALL - U - AR.HZ_CUST_ACCT_SITES_U3 - 1 - TP_HEADER_ID AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N1 - 1 - PARTY_SITE_ID AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N2 - 1 - CUST_ACCOUNT_ID AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N2 - 2 - STATUS AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N2 - 3 - BILL_TO_FLAG AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N3 - 1 - CUST_ACCOUNT_ID AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N3 - 2 - STATUS AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N3 - 3 - SHIP_TO_FLAG AR.HZ_CUST_ACCT_SITES_ALL - N - AR.HZ_CUST_ACCT_SITES_N4 - 1 - ECE_TP_LOCATION_CODE AR.HZ_CUST_ACCT_SITES_ALL_M - U - AR.HZ_CUST_ACCT_SITES_ALL_M_U1 - 1 - CUST_ACCT_SITE_ID AR.HZ_CUST_ACCT_SITES_ALL_M - U - AR.HZ_CUST_ACCT_SITES_ALL_M_U1 - 2 - CUSTOMER_MERGE_HEADER_ID AR.HZ_CUST_ACCT_SITES_ALL_M - U - AR.HZ_CUST_ACCT_SITES_ALL_M_U1 - 3 - MERGE_REQUEST_ID Elapsed: 00:00:02.00 SQL>   Syntax: @tabinx <partial tablename>   @tabinx (0 downloads)

Leave a Reply