Re: [Virtuoso-users] Querying the currently used indexes

[Patrick van Kleef]

HI Sebastian,

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?

Please use the ODBC SQLStatistics call to get this information.


Patrick