Explains index design from access paths

K-657 · Knowledge knobit · Activity: Design the physical data model · Competence: Data modelling

Indexes derived from foreign keys, natural keys and stated access paths.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: Indexes derived from foreign keys, natural keys and stated access paths

How it is assessed: Derives an index set from sample access paths

Related knobits

Needed for

• K-621 Recognises an index set not derived from access paths

All 40 knobits of Design the physical data model.

Source: Data-management practice used by the stage 6 reference and review checklist