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

What is the mutating table and constraining table?

0 Answers  

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

Why we use sql profiler?

0 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---

What is the difference between local and global temporary table?

0 Answers  

---

How many types of privileges are available in sql?

0 Answers  

---

what is check constraint? : Sql dba

1 Answers  

---

Why stored procedure is faster than query?

0 Answers  

---

What is a trigger word?

0 Answers  

---

How many tables can a sql database have?

0 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---