what is Complex index. how to create it?

Question Posted / kolipaka

2 Answers
6509 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is Complex index. how to create it?..

Answer / reddibasha

Do you mean Composite Index?

Composite index is the index created on multiple columns of
a table. A maximum of 16 columns can be used as a composite
index. It can be created at table level only. Unique,
Primary Key and Foreign Key can be composite keys.

Ex:
Create table emp
(eno number,
ename varchar(5),
dob date,
sal number,
dno number,
Primary Key(eno, ename) -- Composite Index
);

Is This Answer Correct ?

2 Yes

2 No

what is Complex index. how to create it?..

Answer / naren patidar

In cluster data of two table store in one object(cluster)
that generates a index that can identify rows of both of
table..

naren

Is This Answer Correct ?

1 Yes

1 No

Post New Answer