[Virtuoso-users] Querying the currently used indexes

[Sebastian Trueg]

Hi,

currently I am using the following query to determine the indexes that
are in use:

SELECT DISTINCT SUBSTRING(ISS_KEY_NAME,10,4)
                                   FROM SYS_INDEX_SPACE_STATS WHERE
                                   ISS_KEY_TABLE='DB.DBA.RDF_QUAD' AND
                                   ISS_KEY_NAME LIKE 'RDF_QUAD_*'

However, this query is very slow. Is there a better alternative?

Thanks a lot,
Sebastian Trueg