Interested to Buy Any Domain ? << Click Here >> for more details...
My SQL is not performing well. Describe how will you fine
tune it?
- 1 Answers
- 6557 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / akbar
Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the bind parameters ibm db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
can all users have the privilage to use the sql statement select * (dml)?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are bind parameters in db2?
What does db2 mean?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Which isolation level provides highest data integrity?
What is an instance in db2?
What is ibm db2 connect?
What is db2? Explain.
How to create db2 table in mainframe?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
