what is Complex index. how to create it?
Answers were Sorted based on User's Feedback
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
);
Is This Answer Correct ? | 2 Yes | 2 No |
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
Is This Answer Correct ? | 1 Yes | 1 No |
What is the use of count (*) in sql?
How do I install microsoft sql?
What will you get by the cursor attribute sql%found?
What is mdb stand for?
Can you have more than one key in a database?
What are the advantages of sql? Explain
Why do we need databases?
What are field types?
Can function return multiple values in sql?
What are data types in pl sql?
what is hash join
Is nosql relational?