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
);

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

Can we create index on primary key?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

What is trigger in sql?

0 Answers  

---

What is %type in sql?

0 Answers  

---

Mention what does the hierarchical profiler does?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

What is a function in oracle pl sql?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

What is full join in sql?

0 Answers  

---

Is sql open source?

0 Answers  

---

what is check constraint? : Sql dba

1 Answers  

---