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
- 29636 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / debasis bose
Using Views, instate of multiple tables.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how is myisam table stored? : Sql dba
Can there be 2 primary keys in a table?
I need a function for a train ticket reservation please answer it thanks in advance
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is an index in sql with example?
What is sql data?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Explain the select statement in sql?
What is the difference between clustered and non-clustered indexes?
What is sql entity?
What are pl/sql packages?
What is sql query optimization?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How do I delete a trigger?
What is java sql connection?
