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

How many types of literals are available in pl sql?

1 Answers  

---

What are aggregate functions in sql?

1 Answers  

---

What is exit statement?

1 Answers  

---

What is posting?

1 Answers  

---

What is data definition language?

1 Answers  

---

How to call DDL statements from pl/sql?

5 Answers  

---

where are cookies actually stored on the hard disk? : Sql dba

1 Answers  

---

What is auto increment in sql?

1 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

what is 'mysqld'? : Sql dba

1 Answers  

---