Search code examples
mysqlphpstormsql-execution-plandatagrip

PhpStorm MySQL connection how to check if query making full table scan

I have a test table with 660.000 rows with dummy books data. I'm trying to learn how index works etc.

But I have one problem: I just want to check if my query is making a full table scan. Is it possible to check it in PhpStorm?

Sample query:

explain ANALYZE select * from books where isbn = 9790085163660 limit 1;
Solution

  • Yes, you can connect to the database from the SQL Console and issue commands manually from there (provided the user has the appropriate permissions of course).