How can I find the unused indexes on a particular table? I've a table in production which has 23 indexes. The job is to find the unused(useless) and delete them.
root@prod-db2:/# mysql --version;
mysql Ver 14.14 Distrib 5.5.18, for solaris10 (i386) using readline 5.1