Changes between Version 6 and Version 7 of Database Optimization
- Timestamp:
- Dec 12, 2006, 1:12:35 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Database Optimization
v6 v7 11 11 12 12 13 David - According to http://www.mysqlperformanceblog.com/2006/11/23/covering-index-and-prefix-indexes/ then "that creates a single index -- those can't be split up" is incorrect, and (node_id, version) does not need its own index. 14 13 15 Nick - if you have lots of metadata, then adding an index on node_id,version is likely to help (we no longer have metadata_name) 14 16