Indexes Count
The statistics show the evolution of the database with respect to the number of indexes; the value is computed as the sum, over all the tables, of the number of indexes per table The revision's number in x-axis of the line chart, is an identification number in place of the real revision's number, which can be found in the attached csv file
SELECT table_schema, count(*) FROM PRISM_STATISTICS s, PRISM_VERSIONS d WHERE table_schema like ? AND (table_name, index_name) not in (SELECT table_name, constraint_name FROM PRISM_TABLE_CONSTRAINTS c WHERE c.table_schema = s.table_schema AND constraint_type like 'PRIMARY%' OR CONSTRAINT_TYPE like 'FOREIGN%') AND d.schema_unique_name = s.table_schema GROUP BY table_schema ORDER BY d.tstart
Index Changes
The statistic show the number of primary keys modified during the lifetime of a table The aggregation level is the table name. This can be used as an index of database stability
The sql analyze the number of columns belonging to the key in each revision of the databas during the table lifetime