var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Selecting all the object with more than five indexes
I searched the forum, but have not found similar problem.
I would like to select all object from my local mysql installation which have more than five indexes. Is this possible?
I have tried to find some solutions via information_schema database, but nothing helped. Basically, I would like to ask following:
SELECT ALL OBJECTS WHERE MORE THAN FIVE INDEXES.
Thanks a lot in advance for resoponses
results: sakila rental 5
, COUNT(DISTINCT constraint_name) AS x
HAVING x >= 5
BY x DESC
Thanks a lot r937!
With small modification works like a charm!
Just one additional question: Are the all records in key_column_usage table indexes?