How do you optimize a stored procedure query?

Question Posted / monika singh

No Answer is Posted For this Question
Be the First to Post Answer

More SQL PLSQL Interview Questions

What does pragma mean?

What does the base_object_type column shows in the user.triggers data dictionary view?

What is the use of %rowtype?

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

What are its different types of dbms?

What is a parameter query?

What is a design view?

What is AUTH_ID and AUTH_USER in pl/sql ?

What is the difference between row level and statement level trigger?

I have a CURSOR then why we need BULK COLLECT again?

How does postgresql compare to "nosql"?

Why stored procedure is faster than query?

For more SQL PLSQL Interview Questions Click Here