mirror of
https://github.com/archtechx/laravel-tips.git
synced 2025-12-12 21:34:03 +00:00
15 lines
No EOL
606 B
Markdown
15 lines
No EOL
606 B
Markdown
---
|
|
title: 'The order of columns in multi-column indices matters'
|
|
tweet_id: '1502367764119314433'
|
|
thread_slug: weekly-thread-2022-10
|
|
author_username: tobias_petry
|
|
images:
|
|
- 'https://pbs.twimg.com/media/FNZ80F6XMAcIeTt.jpg'
|
|
created_at: 2022-03-11T19:36:02+00:00
|
|
slug: the-order-of-columns-in-multi-column-indices-matters
|
|
---
|
|
⚡️ Database Tip
|
|
|
|
Creating indexes is a handcraft learned from experience, multiple-column indexes is a lot more complicated. But it doesn't have to be complicated!
|
|
|
|
Here are 3 simple rules for the column ordering of multiple column indexes, solving 80% of the perf problems. |