Hva er logical vs. physical query plan?
Klikk for å snu kortet
Logical plan: algebraisk, sier hva spørringen gjør (project, select, join). Physical plan: konkretiserer hvordan (hash join vs. SMJ, indeksscan vs. full scan). CBO evaluerer kostnader for ulike physical planer.
Space / Enter for å snu