Part III. Advanced MySQL Usage
Prev
Next
Part III. Advanced MySQL Usage
Table of Contents
14. Creating Schemas and Tables
14.1. Designing a Schema
15. Indexing Data
15.1. Introduction to Indexing
15.2. Types of Indexes
15.3. Choosing Columns to Index
15.3.1. Reviewing Queries for Index Usage
15.3.2. Identifying Slow Queries with the Slow Query Log
15.4. Displaying Table Indexes
15.4.1. Displaying Table Indexes Using the SHOW Command
15.4.2. Displaying Table Indexes Using the INFORMATION_SCHEMA
15.4.3. Displaying Index Information Using MySQL Administrator
15.5. Creating Indexes
15.5.1. Creating Indexes with the CREATE TABLE Statement
15.5.2. Using the CREATE INDEX Syntax
15.5.3. Using ALTER TABLE to Create Indexes
15.5.4. Indexing the Prefix of a Column
15.6. Creating and Using Composite Indexes
15.7. Dropping Indexes
15.8. Using FULLTEXT Indexes
15.9. Using EXPLAIN to Optimize Indexing
16. MySQL Views
16.1. What is a Database View?
17. Triggers
17.1. What Are Triggers?
18. MySQL Stored Procedures
18.1. What is a Stored Procedure?
19. MySQL Storage Engines
19.1. <type> Engine
20. Optimization
20.1. Using EXPLAIN
20.2. Optimizing SELECT Statements
20.3. Optimizing Indexes