# INDEXEs

**URL:** <https://forums.percona.com/t/indexes/1381>\
**Category:** Other MySQL® Questions\
**Created:** [April 14, 2010, 5:00am UTC](https://forums.percona.com/t/indexes/1381 "2010-04-14T05:00:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ittec](https://avatars.discourse-cdn.com/v4/letter/i/e274bd/32.png) [@ittec](https://forums.percona.com/u/ittec)\
**Post date:** [April 14, 2010, 5:00am UTC](https://forums.percona.com/t/indexes/1381/1 "2010-04-14T05:00:35Z")

</div>

Hi

another newbie question 😃

1)I have one innodb TABLE. With 2 fields, ID and VALUE. INT and VARCHAR respectively.

2)I setup ID as PRIMARY KEY.

so, in this veary silly environment, is this PRIMARY KEY a kind of mysql INDEX?

Will PRIMARY KEY help MYSQL to searchs, etc? Or I still need another INDEX?

Thanks!

---

<div class="post-metadata">

**Author:** ![sterin71](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@sterin71](https://forums.percona.com/u/sterin71)\
**Post date:** [April 15, 2010, 3:07am UTC](https://forums.percona.com/t/indexes/1381/2 "2010-04-15T03:07:23Z")

</div>

Yes the primary key is an UNIQUE INDEX.  
It’s just that since it uniquely identifies each record in the table it stands out and exists in (almost) every table and that is why you call it the PRIMARY KEY.

And yes it will be used to speed up searches.

---

<div class="post-metadata">

**Author:** ![ittec](https://avatars.discourse-cdn.com/v4/letter/i/e274bd/32.png) [@ittec](https://forums.percona.com/u/ittec)\
**Post date:** [April 15, 2010, 8:38am UTC](https://forums.percona.com/t/indexes/1381/3 "2010-04-15T08:38:59Z")

</div>

Thank you Sterin!