# How to use Percona server for mysql indexing?

**URL:** <https://forums.percona.com/t/how-to-use-percona-server-for-mysql-indexing/27457>\
**Category:** Other MySQL® Questions\
**Tags:** pmm, mysql, percona\
**Created:** [December 28, 2023, 10:30am UTC](https://forums.percona.com/t/how-to-use-percona-server-for-mysql-indexing/27457 "2023-12-28T10:30:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jayt](https://avatars.discourse-cdn.com/v4/letter/j/e5b9ba/32.png) [@jayt](https://forums.percona.com/u/jayt)\
**Post date:** [December 28, 2023, 10:30am UTC](https://forums.percona.com/t/how-to-use-percona-server-for-mysql-indexing/27457/1 "2023-12-28T10:30:46Z")

</div>

Hello everyone,

I am new to Percona Server for MySQL, and I’m unsure about how to configure MySQL indexes. Could someone guide me on where I can find a list of all the indexes and identify the most useful ones for my table? Your assistance is greatly appreciated.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [December 29, 2023, 12:34am UTC](https://forums.percona.com/t/how-to-use-percona-server-for-mysql-indexing/27457/2 "2023-12-29T00:34:20Z")

</div>

Hello @jayt,  
If you want to see indexes on a table, just run “SHOW CREATE TABLE fooTable” and examine the schema. You will see all indexes.  
If you want to understand the effectiveness of an index, run “EXPLAIN” on a query. For example, `EXPLAIN SELECT * FROM table WHERE colA = 4567` If the optimizer was able to use an index, you will see that index listed. If there was no good index, you will see ‘ALL’ indicating a full-table-scan took place.  
This answer barely scratches the surface of the “Query Optimization” topic. Percona offers a [2-day training course](https://percona.com/training) on query and schema optimization.