How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 27021 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / bala
By avoiding sql statements & select INTO kind of statements.
To improve better creating cursors to hold data.
Indexing is the way to tune the database tables.
so, mostly try to avoid Hard Coding in the select
statements..
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Which language is used in sql?
What are character functions in sql?
What is difference between sql and excel?
What is a delimiter in sas?
what is sql? : Sql dba
what are integrity rules?
what is 'mysqlshow'? : Sql dba
Explain what is a field in a database and record in a database?
Is vs as in pl sql?
What are the limitations of sql express?
What is trigger in pl sql with examples?
What are triggers and its types?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Is oracel sql developer written in java?
How many types of tables are there?
