This section helps you understand and use Oracle indexes to speed up your queries. Creating a new index – show you how to use the CREATE INDEX statement to create an index for one or …

In this tutorial, you will learn how to use the Oracle CREATE INDEX statement to create a new index on one or more columns of a table.

On this website, you can learn Oracle Database fast and easily. This Oracle tutorial was designed for absolute beginners who have never worked with any relational database system, especially …

In this tutorial, you will learn how to use the Oracle function-based index to speed up queries that consist of functions.

In this tutorial, you will learn how to use the Oracle DROP INDEX statement to remove an index from a table.

This tutorial shows you how to use the Oracle SUBSTR () function to extract a substring from a string in the database.

In this tutorial, you will learn how to use Oracle unique index to prevent duplicate values in the indexed column or columns of a table.

In this tutorial, you will learn how to use Oracle bitmap index for indexing columns with low cardinality.

If index is less than upper_bound, index is incremented by one, the statements execute, and control again returns to the top of the loop. When index is greater than upper_bound, the loop …

This tutorial shows you how to use Oracle PRIMARY KEY constraint to create, add, disable, enable, and drop a primary key of a table.