© Frank M. Kromann 2018
Frank M. KromannBeginning PHP and MySQLhttps://doi.org/10.1007/978-1-4302-6044-8_33

33. Indexes and Searching

Frank M. Kromann1 
(1)
Aliso Viejo, CA, USA
 
Chapter 25 introduced the utility of PRIMARY and UNIQUE keys, defining the role of each and showing you how to incorporate them into your table structures. However, indexing plays such an important role in database development that this book would be woefully incomplete without discussing the topic in some detail. In this chapter, the following topics are covered:

  • Database indexing: The first half of this chapter introduces general database indexing terminology and concepts, and it discusses primary, unique, normal, and full-text MySQL indexes.

  • Forms-based searches: The second ...

Get Beginning PHP and MySQL: From Novice to Professional now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial