Lorenzo Alberton - Articles - Extracting META information from Oracle...

SELECT index_name name FROM user_indexes WHERE table_name = 'TEST2' AND generated = 'N' SELECT DISTINCT procedure_name FROM all_procedures

indexing - How to see indexes for a database or... - Stack Overflow

If you want to see all indexes across all databases all at once To get all indexed columns per index in one column in the sequence order.

Querying INFORMATION_SCHEMA | DBA Diaries

Overview of MySQL information_schema Database With Practical...

Глава 9. База данных INFORMATION_SCHEMA

Команда SQL для выборки из базы данных (SELECT, WHERE...)

Useful database analysis queries with INFORMATION_SCHEMA

SELECT USER, COUNT(*) FROM information_schema.PROCESSLIST GROUP BY USER. This gets rid of all information schema tables (since those are all ‘SYSTEM VIEW’s).

Ответы Mail.ru: Решение задачи по SQL

MySQL - Difference between using count(*) and...

SELECT table_rows "Rows Count" FROM information_schema.tables WHERE table_name="Table_Name" AND table_schema="Database_Name" In the mean time between two counts, use the cached value.

SQL Server Row Count for all Tables in a Database