11. Indexes ..... 444 11.1. Introduction ..... 444 11.2. Index Types ..... 445 11.3. Multicolumn Indexes ..... 447 11.4. Indexes and ORDER BY ..... 448 11.5. Combining Multiple Indexes .... . 449 11.6. Unique Indexes ..... 450 11.7. Indexes on Expressions ..... 450 11.8. Partial Indexes ..... 451 11.9. Index-Only Scans and Covering Indexes ..... 454 11.10. Operator Classes and Operator .... 457 11.11. Indexes and Collations ..... 458 11.12. Examining Index Usage ..... 459 12. Full Text Search ..... 461 12.1. Introduction ..... 461 12.2. Tables and Indexes ..... 465 12.3.

10.2.7 Troubleshoot Lock Conflicts ··· 1380 10.2.8 Troubleshoot Inconsistency Between Data and Indexes ··· 1393 10.3 Diagnostic Methods ··· 1396 10.3.1 SQL Diagnostics ··· 1396 10.3.2 Statement Summary ··· 3958 14.12.3 Data Types ··· 4392 14.12.4 Functions and Operators ··· 4418 14.12.5 Clustered Indexes ··· 4617 14.12.6 Vector Search Index ··· 4623 14.12.7 Constraints ··· 4631 14.12.8 Generated Columns href="https://docs.pingcap.com/tidb/v8.4/partitioned-table#global- → indexes">Global indexes for partitioned tables (GA) Global indexes can effectively improve the efficiency of retrieving non- → partitioned

… 423 Indexes … 424 11.1. Introduction … 424 11.2. Index Types … 425 11.3. Multicolumn Indexes … 427 11.4. Indexes and ORDER BY … 428 11.5. Combining Multiple Indexes … 429 11.6. Unique Indexes … 430 430 11.7. Indexes on Expressions … 430 11.8. Partial Indexes … 431 11.9. Index-Only Scans and Covering Indexes … 434 11.10. Operator Classes and Operator Families … 437 11.11. Indexes and Collations … 439 Examining Index Usage … 439 Full Text Search … 441 12.1. Introduction … 441 12.2. Tables and Indexes … 445 12.3. Controlling Text Search … 447 12.4. Additional Features … 455 12.5. Parsers … 461 12

316 11. Indexes .....318 11.1. Introduction .....318 11.2. Index Types .....319 11.3. Multicolumn Indexes .....321 11.4. Indexes and ORDER BY .....322 11.5. Combining Multiple Indexes .....323 323 11.6. Unique Indexes .....324 11.7. Indexes on Expressions .....324 11.8. Partial Indexes .....325 11.9. Operator Classes and Operator Families .....327 11.10. Indexes and Collations .....329 ...333 12.1.3. Configurations .....334 12.2. Tables and Indexes .....334 12.2.1. Searching a Table .....334 12.2.2. Creating Indexes .....335 12.3. Controlling Text Search .....336 12.3.1.

Constructs ...382 11. Indexes ...385 11.1. Introduction ...385 11.2. Index Types ...386 11.3. Multicolumn Indexes ...388 11.4. Indexes and ORDER BY ...389 11.5. Combining Multiple Indexes ...390 11.6. Unique Unique Indexes ...391 11.7. Indexes on Expressions ...392 11.8. Partial Indexes ...392 11.9. Operator Classes and Operator Families ...395 11.10. Indexes and Collations ...397 11.11. Index-Only Scans 403 12.1.3. Configurations ... 405 12.2. Tables and Indexes ... 405 12.2.1. Searching a Table ... 405 12.2.2. Creating Indexes ... 406 12.3. Controlling Text Search ... 407 12.3.1

1. Indexes ..... 298 11.1. Introduction ..... 298 11.2. Index Types ..... 299 11.3. Multicolumn Indexes ..... 301 11.4. Indexes and ORDER BY ..... 302 11.5. Combining Multiple Indexes .... 302 11.6. Unique Indexes ..... 303 11.7. Indexes on Expressions ..... 304 11.8. Partial Indexes ..... 304 11.9. Operator Classes and Operator Families ..... 307 11.10. Indexes and Collations .. 311 12.1.3. Configurations ..... 312 12.2. Tables and Indexes ..... 313 12.2.1. Searching a Table ..... 313 12.2.2. Creating Indexes ..... 314 12.3. Controlling Text Search ..... 315 12.3

Constructs ... 307 Indexes ... 309 11.1. Introduction ... 309 11.2. Index Types ... 310 11.3. Multicolumn Indexes ... 312 11.4. Indexes and ORDER BY ... 313 11.5. Combining Multiple Indexes ... 313 11.6 6. Unique Indexes ... 314 11.7. Indexes on Expressions ... 315 11.8. Partial Indexes ... 315 11.9. Operator Classes and Operator Families ... 318 11.10. Indexes and Collations ... 319 11.11. Examining 322 12.1.3. Configurations ... 323 12.2. Tables and Indexes ... 324 12.2.1. Searching a Table ... 324 12.2.2. Creating Indexes ... 325 12.3. Controlling Text Search ... 326 12.3.1

11. Indexes ..... 302 11.1. Introduction ..... 302 11.2. Index Types ..... 303 11.3. Multicolumn Indexes ..... 305 11.4. Indexes and ORDER BY ..... 306 11.5. Combining Multiple Indexes .... 11.6. Unique Indexes ..... 307 11.7. Indexes on Expressions ..... 308 11.8. Partial Indexes ..... 308 11.9. Operator Classes and Operator Families ..... 311 11.10. Indexes and Collations 12.1.3. Configurations ..... 318 12.2. Tables and Indexes ..... 318 12.2.1. Searching a Table ..... 318 12.2.2. Creating Indexes ..... 319 12.3. Controlling Text Search ..... 320

288 11. Indexes .....290 11.1. Introduction .....290 11.2. Index Types .....291 11.3. Multicolumn Indexes .....292 11.4. Indexes and ORDER BY .....294 11.5. Combining Multiple Indexes .....294 294 11.6. Unique Indexes .....295 11.7. Indexes on Expressions .....296 11.8. Partial Indexes .....296 11.9. Operator Classes and Operator Families .....299 11.10. Examining Index Usage .....300 12.1.3. Configurations ..... 305 12.2. Tables and Indexes ..... 305 12.2.1. Searching a Table ..... 305 12.2.2. Creating Indexes ..... 306 12.3. Controlling Text Search ..... 307

11. Indexes ..... 271 11.1. Introduction ..... 271 11.2. Index Types ..... 272 11.3. Multicolumn Indexes ..... 273 11.4. Indexes and ORDER BY ..... 274 11.5. Combining Multiple Indexes .... . 275 11.6. Unique Indexes ..... 276 11.7. Indexes on Expressions ..... 276 11.8. Partial Indexes ..... 277 11.9. Operator Classes and Operator Families ..... 279 11.10. Examining Index Usage 283 12.1.3. Configurations ..... 284 12.2. Tables and Indexes ..... 285 12.2.1. Searching a Table ..... 285 12.2.2. Creating Indexes ..... 286 12.3. Controlling Text Search ..... 287 12.3