C3 (2 points)

https://knobit.org/id/task/dm-physical-postgres/C3

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/C3
rdfs:label	C3 (2 points) en
schema:hasPart	dm-physical-postgres C3: index set derived from access paths
schema:identifier	C3
schema:position	3
schema:text	Index set derived from access paths, 1 each: (a) the missing indexes are added and each comment cites what it serves: payment (account_id, booked_at) for AP-1 and for the foreign key, so deleting or locking an account no longer scans payment; standing_order (next_due_date) for AP-5, and an index on its new foreign key; (b) the indexes no access path asks for are removed or marked provisional: the five single-column indexes on payment (amount, currency, status, created_at, description), and ix_ct2025_card on (card_id), which (card_id, transaction_at) already covers. Both halves of (a) are needed for its point; for (b), the payment indexes are needed and the redundant card index is expected. en

Used by

has question	Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills)
schema:isPartOf	dm-physical-postgres C3: index set derived from access paths