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 are pl/sql packages?

0 Answers  

---

How to avoid duplicate records in a query?

0 Answers  

---

Can we insert data in view?

0 Answers  

---

Explain spool.

0 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

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

0 Answers  

---

How to move files from one directory to another in pl sql?

0 Answers  

---

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

---