Interested to Buy Any Domain ? << Click Here >> for more details...
What are some characteristics of columns that benefit from
indexes?
- 1 Answers
- 4539 Views
- I also Faced
- E-Mail Answers
Answer / s
primary key, foreign key, Joins are often performed on
primary and foreign key columns. columns frequently coded
in the WHERE clause, ORDER BY, GROUP BY, DISTINCT, columns
which are searched or joined over less than 5-10% of the
rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What are common abends
what is datacom db?
What are types of indexes?
What is a cursor and what is its function?
List out the data types available.
What is copy pending status in db2?
What are the functions in DB2?
What is the difference between plan and package in db2?
What is the difference between static and dynamic SQL?
Q3. How will you fetch duplicate values from a DB2 table?
What will the FREE command do to a plan?
COBOL 
