What is INDEX_BY_BINARY_INTEGER?

What is INDEX_BY_BINARY_INTEGER?

BINARY_INTEGER is an indexing data type for associative arrays that is a subtype if INETGER. Values that can be taken up by this data type range from -2,147,483,647 to 2,147,483,647.

Example:
TYPE my_array_t IS TABLE OF VARCHAR2(100)
INDEX BY BINARY_INTEGER

What is INDEX_BY_BINARY_INTEGER?

BINARY_INTEGER is a PL/SQL data type defined as a subtype of INTEGER in the STANDARD package and is used for storing signed integers.

It can take values between -2,147,483,647 and 2,147,483,647
What is index and explain its purpose
An index is a pointer to a location of data. The purpose of an index is to make SQL queries run faster.....
What are the guidelines to decide which table s to index?
On rebuilding an Index, the existing index is dropped and a new one is built. This operation can consume a lot of time and resources......
What are the guidelines to decide which column to index?
Non-key columns can be dropped from a table only after the non-key index is dropped first...
Post your comment

Related Content

Follow us

▲