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

24.11.2023

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

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

Thanks. I understand you.

0

24.11.2023

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

24.11.2023

Похожие чаты

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

5 ответов

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