Listing indexes

You can use a table function to list all Lucene indexes.

After the luceneSupport tool has been loaded, anyone can list the Lucene indexes by selecting from the following table function:

LUCENESUPPORT.LISTINDEXES()
RETURNS TABLE
(
    SCHEMANAME  VARCHAR( 128 ),
    TABLENAME VARCHAR( 128 ),
    COLUMNNAME VARCHAR( 128 ),
    LASTUPDATED TIMESTAMP,
    LUCENEVERSION VARCHAR( 20 ),
    ANALYZER VARCHAR( 32672 ),
    INDEXDESCRIPTORMAKER VARCHAR( 32672 )
)

Example

    -- list all the indexes
    SELECT * FROM TABLE( LUCENESUPPORT.LISTINDEXES() ) T;