How do we specify index to include or not during bind
process.
- 1 Answers
- 2222 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / Deepak Singh
In DB2, you can specify an index for inclusion or exclusion during the bind process using the INCLUDE and EXCLUDE keywords respectively. Here is a simple example:
CREATE INDEX idx_mytable ON mytable (column1) INCLUDE (column2);
This will create an index on column1, but also include column2 in the index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is the latest version of ibm db2?
