John used the EXPLAIN statement for a SQL query. He observes…
John used the EXPLAIN statement for a SQL query. He observes that the database is performing a “full table scan” (reading every single row) on a massive table instead of looking up specific rows. What is the most logical next step for John?