Understanding Indexing [Webinar]
July 31st 2012 Time: 2PM EDT / 11AM PDT
From the post:
Three rules on making indexes around queries to provide good performance
Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase application performance is to optimize the indexes. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance.
[graphic button omitted]
This webinar is a general discussion applicable to all databases using indexes and is not specific to any particular MySQL® storage engine (e.g., InnoDB, TokuDB®, etc.). The rules are explained using a simple model that does NOT rely on understanding B-trees, Fractal Tree® indexing, or any other data structure used to store the data on disk.
Indexing is one of those “overloaded” terms in information technologies.
Indexing can refer to:
- Database indexing
- Search engine indexing
- Human indexing
just to name a few of the more obvious uses.
To be sure, you need to be aware of, if not proficient at, all three and this webinar should be a start on #1.
PS: If you know of a more complete typology of indexing, perhaps with pointers into the literature, please give a shout!