DBA Data[Home] [Help]

VIEW: APPLSYS.FND_INDEXES#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, TABLE_ID TABLE_ID, INDEX_ID INDEX_ID, INDEX_NAME INDEX_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AUTO_SIZE AUTO_SIZE, INI_TRANS INI_TRANS, MAX_TRANS MAX_TRANS, INITIAL_EXTENT INITIAL_EXTENT, NEXT_EXTENT NEXT_EXTENT, MIN_EXTENTS MIN_EXTENTS, MAX_EXTENTS MAX_EXTENTS, PCT_FREE PCT_FREE, PCT_INCREASE PCT_INCREASE, UNIQUENESS UNIQUENESS, DESCRIPTION DESCRIPTION, ZD_EDITION_NAME ZD_EDITION_NAME from "APPLSYS"."FND_INDEXES"
View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, TABLE_ID TABLE_ID
, INDEX_ID INDEX_ID
, INDEX_NAME INDEX_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AUTO_SIZE AUTO_SIZE
, INI_TRANS INI_TRANS
, MAX_TRANS MAX_TRANS
, INITIAL_EXTENT INITIAL_EXTENT
, NEXT_EXTENT NEXT_EXTENT
, MIN_EXTENTS MIN_EXTENTS
, MAX_EXTENTS MAX_EXTENTS
, PCT_FREE PCT_FREE
, PCT_INCREASE PCT_INCREASE
, UNIQUENESS UNIQUENESS
, DESCRIPTION DESCRIPTION
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "APPLSYS"."FND_INDEXES"