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

Why do we create views in sql?

0 Answers  

---

What is the purpose of a sql?

0 Answers  

---

Is left join and outer join same?

0 Answers  

---

What are the different types of sql commands?

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

---

What are the set operators in sql?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

What is difference between pl and sql?

0 Answers  

---

What programs use sql?

0 Answers  

---

Why do we use partitions in sql?

0 Answers  

---

Does sap use sql?

0 Answers  

---