Listing indexes You can use a table function to list all Lucene indexes. luceneSupport optional toollisting 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;