Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

_db_index_key

Represents key information on an index. An index for index_of is created.

Attribute Name

Data Type

Description

index_of

_db_index

Index to which the key attribute belongs

key_attr_name

VARCHAR(255)

Name of the attribute that comprises the key

key_order

INTEGER

Order of the attribute in the key. Begins with 0.

asc_desc

INTEGER

1 if the order of attribute values is descending, and 0 otherwise.

key_prefix_length

INTEGER

Length of prefix to be used as a key

func

VARCHAR(255)

Functional expression of function based index

Example

The following example shows how to retrieve the names of index that belongs to the class.

SELECT class_of.class_name, SEQUENCE(SELECT key_attr_name

                                     FROM _db_index_key k

                                     WHERE k in i.key_attrs)

FROM _db_index i

WHERE key_count >= 2;

  class_of.class_name   sequence((select key_attr_name from _db_index_key k where k in

i.key_attrs))

============================================

  '_db_partition'       {'class_of', 'pname'}

  '_db_method'          {'class_of', 'meth_name'}

  '_db_attribute'       {'class_of', 'attr_name'}

  'participant'         {'host_year', 'nation_code'}

  'game'                {'host_year', 'event_code', 'athlete_code'}

  'record'              {'host_year', 'event_code', 'athlete_code', 'medal'}

  'history'             {'event_code', 'athlete'}