xxxxxxxxxx
-- Creating an index on a table
CREATE INDEX index_name
ON table_name (column_name);
xxxxxxxxxx
SELECT DISTINCT
TABLE_NAME,
INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';
xxxxxxxxxx
1 Clustered index
2 Non clustered index,
3 BTREE(Balanced Tree) index,
4 Unique Index,
5 Composite Index,
6 Function based index
7 Bitmap index