Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 29627 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
What is the difference between unique and primary key constraints?
Can you upgrade sql express to full sql?
How do I turn a list into a table?
how to create a test table in your mysql server? : Sql dba
What has stored procedures in sql and how we can use it?
What is the difference between truncate and drop statements?
What is clause?
What does truncate mean in sql?
what are all the different types of indexes? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is the use of count (*) in sql?
Explain scalar functions in sql?
What is sql dialect?
What are stuff and replace function?
Explain the rollback statement?
