Práctica 2- Apartado C

De FdIwiki ABD
Saltar a: navegación, buscar

1. delete plan_table; EXPLAIN PLAN INTO plan_table

    FOR (SELECT *
     FROM cliente
     WHERE DNI in (select DNI from moroso where dni != '%01'));

- Esta consulta utiliza nested loops, full table scan e Index unique scan.

2. delete plan_table; EXPLAIN PLAN INTO plan_table

    FOR (SELECT *
     FROM cliente
     WHERE DNI = '00000001')
     UNION (SELECT *
     	FROM cliente
         WHERE direccion = 'direc 12');

- Esta consulta utiliza Sort unique, Union-all, Table access by index rowid, index unique scan y table access full.

3. delete plan_table; EXPLAIN PLAN INTO plan_table

    FOR ( SELECT *
        FROM moroso
    	    WHERE dni in (SELECT dni FROM invierte);

- Esta consulta utiliza Merge Join Semi, Table access by index rowed, index full scan y sort unique.