This part covers prologue to lists, their sorts, creation and dropping.
Record is a lot of pointers, which can allude to lines in a table, hinders in MDC or ITC tables, XML information in a XML stockpiling object that are coherently requested by the estimations of at least one keys. It is made on DB2 table segments to accelerate the information access for the questions, and to group and segment the information effectively. It can likewise improve the exhibition of activity on the view. A table with a one of a kind list can have columns with one of a kind keys. Contingent upon the table necessities, you can take various kinds of lists.
- Types of indexes
- Special and Non-Unique records
- Grouped and non-bunched records
For making special records, you utilize following language structure:
db2 create unique index <index_name> on <table_name>(<unique_column>) include (<column_names..>)
Example: To create index for “shopper.sales1” table.
db2 create unique index sales1_indx on shopper.sales1(id) include (itemname)
For dropping the index, you use the following syntax:
db2 drop unique index <index_name> on <table_name>(<unique_column>) include (<column_names..>)
db2 drop index sales_index