How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 26984 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / hrishi
To reduce the context switches between the SQL Engine and
PL/SQL engine. We can use Bulk Bind Concept to this...
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is pragma in sql?
what is a primary key? : Sql dba
Which nosql database is best?
What do you understand by case manipulation functions?
What is a behavioral trigger?
What is the most restrictive isolation level? : Transact sql
What is nvl?
What are the 3 modes of parameter?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is a clob in sql?
Explain the difference between 'between' & 'and' operators in sql
What is record type in pl sql?
define join and explain different type of joins? : Sql dba
Do we need to create index on primary key?
What is indexing oracle sql?
