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 does where 1/2 mean in sql?

0 Answers  

---

What does stand for in sql?

0 Answers  

---

Why are indexes and views important to an organization?

0 Answers  

---

what is msql? : Sql dba

0 Answers  

---

What is difference between my sql and sql?

0 Answers  

---

---

What is difference between pls_integer and integer?

0 Answers  

---

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

---

What is plpgsql language?

0 Answers  

---

What is $$ in sql?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

What is a database link?

3 Answers  

---

what is a tablespace? : Sql dba

0 Answers  

---