In a SQL database. Are the primary keys indexed? If

Normally yes (I didn't check every dbms), so if you lookup by PK is fast. If you need to access the data by other patterns (ex filtering by "status" and "event_type" and "event_date" in an hypotetical event table) it's a good practice to index also these data, according to your specific patterns

0

5 месяцев назад

704682000 4164616D73 Автор вопроса

Marco De Nittis
Normally yes (I didn't check every dbms), so if yo...

Thanks. I understand you.

0

5 месяцев назад

Chandala Masimpe · Accepted Answer

Chandala Masimpe

If the primary key is defined why you want to index a primary key? Index other columns but not Primary Key

0

5 месяцев назад

Похожие чаты

In a SQL database. Are the primary keys indexed? If

5 ответов

Похожие вопросы