@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/dm-physical-postgres/C3> a edu:Question ;
    rdfs:label "C3 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/C3> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-616> ;
    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 .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-616> rdfs:label "dm-physical-postgres C3: index set derived from access paths"@en .