Menu
It might be very obvious but I don't know how to check if a field has an index with phpMyAdmin.
It's probably so obvious that nobody ever asked it so I could not find something in Google either.
251
To see the index for a specific table use SHOW INDEX: SHOW INDEX FROM yourtable; To see indexes for all tables within a specific schema you can use the STATISTICS table from INFORMATION_SCHEMA: SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.
To check if index exists on column uses sp_helpindex function or extract information from sys. tables, sys. columns, sys. indexes, sys.
Write "explain " in front of your query. The result will tell you which indexes might be used.
If you use psql to access the PostgreSQL database, you can use the \d command to view the index information for a table.
Try this:
SHOW INDEX FROM yourtable;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
