1. | To create an index on the LastName column of the Employee table | | |
2. | Created an index based on the uppercase evaluation of the employe's first name field | | |
3. | Create two indexes for one single table | | |
4. | Create an index reverse | | |
5. | Function-based Indexes | | |
6. | simple index organized table | | |
7. | Create an index, and add primary key to use that index | | |
8. | Create index along with the column definition | | |
9. | Create index for combined columns | | |
|
10. | Create index for upper case last name | | |
11. | Create index on cluster | | |
12. | Create index with tablespace | | |
13. | Create unique index and check it in user_ind_columns and user_cons_columns | | |
14. | Demonstrate a bitmap join index. | | |
15. | CREATE UNIQUE INDEX | | |
16. | Create a fully indexed table named myCode | | |
17. | Create Non-Unique index | | |
18. | indextype is ctxsys.context | | |
19. | create unique index with case ... when statement | | |