The Name column of a QEP displays the object accessed by the Operation column in

Question

The Name column of a QEP displays the object accessed by the Operation column in that row. Code and execute a query verifying that the index for the PK of the countries table would be accessed by the QEP. Do this querying the all_indexes DD view; doing so proves that the index referenced in the Name column of the QEP exists. You are using SQL*Plus and Oracle.

The previous query in the assignment asked for select count(*) from SH.customers where SH.customers.country_id NOT IN (select country_id from SH.countries);

Explanation / Answer

not getting what exactly you wanted to ask as per my thinking this is the answer for your question

SELECT COUNT SH.customers.country_id FROM SH.customers

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.