PostgreSQL Combined vs Independent Indexes 09/12

preview_player
Показать описание
Should you use multiple individual indexes for each field or a concatenation of multiple fields?

If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.

Use the link below to get a 60% OFF.

PostgreSQL High-Performance Tuning Guide - Full Course
Рекомендации по теме
Комментарии
Автор

according to your example last_name = 'Doe' AND department = 'BI' is possible but i think order should be reversed as index created department = 'BI' AND last_name = 'Doe' . Please answer if iam wrong or correct and where iam wrong

keshavb