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
- 6758 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / 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 |
List out the three types of page locks that can be held.
How do you do the EXPLAIN of a dynamic SQL statement?
What happens to the PLAN if index used by it is dropped?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
what is the use of bind parameter, Replace?
How is deadlock resolved?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is table space in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
How will you return the number of records in table?
COBOL 
