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
- 29660 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 least restrictive isolation level? : Transact sql
explain the difference between myisam static and myisam dynamic. : Sql dba
Are views faster than queries?
Can we use ddl commands in pl sql?
How delete all records from table in sql?
What is an index in sql with example?
What is case function?
What programs use sql?
What is indexing in sql and its types?
how to use myisamchk to check or repair myisam tables? : Sql dba
what is bdb (berkeleydb)? : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is db journal file?
what is rollback? : Sql dba
How to write a query to show the details of a student from students table whose
