Month: April 2023

Exams of Oracle . Index Case Summary . The Clustering Factor

Multiple Indexes on the Same Column Combinations-Indexes

On 26/04/2023 by

Prior to Oracle Database 12c, you could not have multiple indexes defined on one table with the exact same combination of columns. For example:$ sqlplus eoda/foo@PDB1SQL> create table t(x int);Table created.SQL> create index ti on t(x);Index created.SQL> create bitmap index tb on t(x) invisible; Starting with 12c, you can define multiple indexes on the same Read More

Character Strings . Exams of Oracle . The Clustering Factor

Function-Based Index Solution-Indexes

On 24/04/2023 by

The concept here is that you’re building an index and applying a function to it in a way that limits the length of the index key and also results in a usable index. Here, I use the same code (as in the prior section) to create a table with an extended column and populate it Read More