Mysql indexes: Revision history

30 October 2023

• curprev 18:5418:54, 30 October 2023‎ Will talk contribs‎ 5,936 bytes −117‎ →‎Index Column Order

1 June 2023

• curprev 18:1618:16, 1 June 2023‎ Will talk contribs‎ 6,053 bytes +118‎ →‎Index Column Order

24 September 2022

• curprev 20:0720:07, 24 September 2022‎ Will talk contribs‎ 5,935 bytes −280‎ →‎Index Strategies
• curprev 19:2919:29, 24 September 2022‎ Will talk contribs‎ 6,215 bytes +4‎ →‎Overview
• curprev 19:2919:29, 24 September 2022‎ Will talk contribs‎ 6,211 bytes +558‎ →‎Usage
• curprev 16:4516:45, 24 September 2022‎ Will talk contribs‎ 5,653 bytes +188‎ →‎Documentation
• curprev 16:4516:45, 24 September 2022‎ Will talk contribs‎ 5,465 bytes +111‎ →‎Index
• curprev 16:4416:44, 24 September 2022‎ Will talk contribs‎ 5,354 bytes −1‎ →‎Index Types
• curprev 16:4216:42, 24 September 2022‎ Will talk contribs‎ 5,355 bytes +192‎ →‎NULL in a multi-column index
• curprev 16:1216:12, 24 September 2022‎ Will talk contribs‎ 5,163 bytes +157‎ →‎Beware of Range Queries
• curprev 16:1116:11, 24 September 2022‎ Will talk contribs‎ 5,006 bytes +174‎ →‎Multi-Column Index

10 September 2022

• curprev 23:3423:34, 10 September 2022‎ Will talk contribs‎ 4,832 bytes −107‎ →‎Index Datastructure Types
• curprev 23:3323:33, 10 September 2022‎ Will talk contribs‎ 4,939 bytes +61‎ →‎Usage
• curprev 23:1823:18, 10 September 2022‎ Will talk contribs‎ 4,878 bytes +368‎ →‎Documentation
• curprev 16:3916:39, 10 September 2022‎ Will talk contribs‎ 4,510 bytes +192‎ No edit summary
• curprev 03:2203:22, 10 September 2022‎ Will talk contribs‎ 4,318 bytes +533‎ →‎Multi-Column Index

6 September 2022

• curprev 05:2605:26, 6 September 2022‎ Will talk contribs‎ 3,785 bytes −36‎ →‎Multi-Column Index
• curprev 05:2505:25, 6 September 2022‎ Will talk contribs‎ 3,821 bytes +115‎ →‎Multi-Column Index
• curprev 05:2505:25, 6 September 2022‎ Will talk contribs‎ 3,706 bytes +86‎ →‎Multi-Column Index
• curprev 05:2405:24, 6 September 2022‎ Will talk contribs‎ 3,620 bytes +374‎ →‎Multi-Column Index
• curprev 05:0705:07, 6 September 2022‎ Will talk contribs‎ 3,246 bytes +280‎ →‎Index Datastructure Types

4 September 2022

• curprev 22:0522:05, 4 September 2022‎ Will talk contribs‎ 2,966 bytes +630‎ →‎Multi-Column Index
• curprev 21:2921:29, 4 September 2022‎ Will talk contribs‎ 2,336 bytes +308‎ →‎Hash
• curprev 20:4320:43, 4 September 2022‎ Will talk contribs‎ 2,028 bytes +707‎ →‎Index Types
• curprev 20:3820:38, 4 September 2022‎ Will talk contribs‎ 1,321 bytes +105‎ →‎Index Types
• curprev 20:1420:14, 4 September 2022‎ Will talk contribs‎ 1,216 bytes +20‎ →‎Hash
• curprev 20:1320:13, 4 September 2022‎ Will talk contribs‎ 1,196 bytes +87‎ →‎Hash
• curprev 20:1220:12, 4 September 2022‎ Will talk contribs‎ 1,109 bytes +97‎ →‎BTree
• curprev 20:1120:11, 4 September 2022‎ Will talk contribs‎ 1,012 bytes +78‎ →‎Index Types
• curprev 20:1120:11, 4 September 2022‎ Will talk contribs‎ 934 bytes +41‎ →‎BTree
• curprev 20:1020:10, 4 September 2022‎ Will talk contribs‎ 893 bytes +893‎ Created page with "Indexes use various datastructures to store data to prevent full scans of all rows in the table. = Index Types = <blockquote> == BTree == A binary tree. Default for persisted storage engines. Optimize Queries that are * sorted * field prefixes * range (less than 10, between C and F) But not queries * field suffixes == Hash == A hash table. Default for the memory engine.<br> hash-collisions are accounted for, but each key with the same hash will need to be checked..."