--- title: ShopPerformance - MySQL-Query without Index description: Optimizing database queries shortens their execution time and improves query throughput. --- [Skip to content](https://knowledge.maxcluster.de/en/mysql-query-without-index#main-content) - [English](https://knowledge.maxcluster.de/en/mysql-query-without-index) - [Deutsch](https://knowledge.maxcluster.de/mysql-query-ohne-index) English Show submenu for translations [![maxcluster\_byteamblue\_logo\_main](https://knowledge.maxcluster.de/hubfs/maxcluster_byteamblue_logo_main.svg)](https://knowledge.maxcluster.de/en) Open main navigation Close main navigation - - [English](https://knowledge.maxcluster.de/en/mysql-query-without-index) - [Deutsch](https://knowledge.maxcluster.de/mysql-query-ohne-index) English Show submenu for translations - [maxcluster.de/en](https://maxcluster.de/en) [maxcluster.de/en](https://maxcluster.de/en) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base (en)](https://knowledge.maxcluster.de/en) 2. [Managed Center](https://knowledge.maxcluster.de/en/managed-center) 3. [ShopPerformance](https://knowledge.maxcluster.de/en/managed-center#shopperformance) September 19, 2025 # ShopPerformance - MySQL-Query without Index ## Optimizing database queries shortens their execution time and improves query throughput. **Please note:** The information in this article refers exclusively to our **ShopPerformance** tool, which you can use to identify potential performance improvements in your online shop. ### **Background** Database servers can process thousands of queries per second, which are a central part of many applications. Optimizing these queries shortens their execution time and improves query throughput. To answer the query, the database server must find data in tables. Ideally, a so-called index is used for this purpose, which can be thought of as an ordered index in a dictionary. This index is very small in comparison to the dictionary, uses a binary search tree and through the alphabetical order the pages of the words can be found quickly. The absence of such an index can result in the need to search all rows of the tables involved in the query. Since the indexes are very small in comparison, it is (almost) always worthwhile to create missing indexes subsequently if necessary. ### **Solution** To check how a query is executed, the MySQL commands `EXPLAIN` bzw. [*`EXPLAIN ANALYZE`*](https://dev.mysql.com/blog-archive/mysql-explain-analyze/) can be placed before the query. With the command `SHOW INDEX FROM #Tabellenname#;` it is possible to check which indexes are currently available for a table. If the result shows that an index can be inserted here, it can be created with the `CREATE INDEX` command. The result of MySQL queries is not changed by existing indexes. Therefore, you can easily insert an index for applications that have been developed externally. To find MySQL queries that can be optimized, the use of a [profiler](https://maxcluster.de/en/blog/2017/04/identifying-bottlenecks-profiler-blogseries) can be helpful. Especially for queries that have a long execution time, it should be checked whether an index is used for all tables. It is also possible to determine from the [Performance Scheme](https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html) which queries are executed without an index. The following command can be used for this purpose: `SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, SUM_TIMER_WAIT/1000000000000 SUM_TIMER_WAIT_SEC FROM performance_schema.events_statements_summary_by_digest where last_seen > (date(now()) - Interval - 5 minute) AND SCHEMA_NAME IS NOT NULL AND SCHEMA_NAME NOT IN("information_schema", "mysql", "performance_schema") and DIGEST_TEXT not like "SHOW%" AND SUM_NO_INDEX_USED > 0 order by (sum_timer_wait_sec) desc limit 5 \G` Our **ShopPerformance** tool can also display corresponding queries. If you require any further assistance, please contact our support team by phone at +49 5251/414130 or by email at [support@maxcluster.de](mailto:support@maxcluster.de)  - [Managed Center](https://knowledge.maxcluster.de/en/managed-center#main-content) - [ShopPerformance](https://knowledge.maxcluster.de/en/managed-center#shopperformance) - [ShopSecurity](https://knowledge.maxcluster.de/en/managed-center#shopsecurity) - [General information](https://knowledge.maxcluster.de/en/general-information) - [Magento](https://knowledge.maxcluster.de/en/magento#main-content) - [Information](https://knowledge.maxcluster.de/en/magento#information) - [Shopware](https://knowledge.maxcluster.de/en/shopware#main-content) - [Instructions](https://knowledge.maxcluster.de/en/shopware#instructions) [![maxcluster-logo\_schwarz\_rot\_ohne\_claim\_cmyk](https://knowledge.maxcluster.de/hs-fs/hubfs/maxcluster-logo_schwarz_rot_ohne_claim_cmyk.png?width=200&height=31&name=maxcluster-logo_schwarz_rot_ohne_claim_cmyk.png "maxcluster-logo_schwarz_rot_ohne_claim_cmyk")](https://maxcluster.de/) Copyright © 2025, maxcluster GmbH