How do you optimize a stored procedure in sql?

Question Posted / abhishek mishra

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

More SQL PLSQL Interview Questions

What is trigger and stored procedure in sql?

What trigger means?

How do you add a column to a table?

Can we insert data into view?

Is it mandatory for the primary key to be given a value when a new record is inserted?

What cursor type do you use to retrieve multiple recordsets?

Is it possible to sort a column using a column alias?

Where the Pre_defined_exceptions are stored ?

What are Global Temporary tables

what is online transaction processing (oltp)? : Sql dba

What is Overloading of procedures ?

What is rowtype?

For more SQL PLSQL Interview Questions Click Here