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 online transaction processing (oltp)?

0 Answers  

---

Is sql a oracle?

0 Answers  

---

What is database sql?

0 Answers  

---

Explain what is a database?

0 Answers  

---

What is a sql trace file?

0 Answers  

---

What is sql query limit?

0 Answers  

---

What are different types of tables in sql?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

What does rownum mean in sql?

0 Answers  

---

What does data normalization mean?

0 Answers  

---

Write a sql select query that only returns each name only once from a table?

0 Answers  

---