Title: Database SQL Queries table scanning
Last modified: August 12, 2021

---

# Database SQL Queries table scanning

 *  [timxjr1300](https://wordpress.org/support/users/timxjr1300/)
 * (@timxjr1300)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/database-sql-queries-table-scanning/)
 * I have a self hosted wordpress site which has been running for years. It’s all
   OK.
    Recently I have used PHPMyAdmin to understand how the database is being 
   used and I have come across the “Advisor” facility which suggests improvements
   that could be made to increase database efficiency.
 * It seems that a lot of queries are performing table scans, not using indexes 
   and inefficient joins which are all very bad from a database performance point
   of view.
 * So my general question or observation is…
    When creators write wordpress itself
   and/or plugins, are they required to ensure that database use is as efficient
   as possible and use the more efficient database engine rather than inefficient
   scanning queries?
    -  This topic was modified 4 years, 9 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).
      Reason: Moved to Fixing WordPress, this is not an Everything else WordPress
      topic

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [corenominal](https://wordpress.org/support/users/corenominal/)
 * (@corenominal)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/database-sql-queries-table-scanning/#post-14764091)
 * Hi 🙂
 * Answering your question: no, it is not a requirement to write the most efficient
   queries possible, although I’m sure many developers aspire to do so.
 * Answering your observation: to quote the WordPress site:
 * > Whether you’re a budding developer, a designer, or just like helping out, we’re
   > always looking for people to help make WordPress even better.
 * See [Make WordPress](https://make.wordpress.org/) for more information.
 *  Thread Starter [timxjr1300](https://wordpress.org/support/users/timxjr1300/)
 * (@timxjr1300)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/database-sql-queries-table-scanning/#post-14764906)
 * Thanks for your reply

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database SQL Queries table scanning’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [timxjr1300](https://wordpress.org/support/users/timxjr1300/)
 * Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/database-sql-queries-table-scanning/#post-14764906)
 * Status: not a support question

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics