Answer Posted / 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 |
Post New Answer View All Answers
What does the file extension accdb stand for?
What pl/sql package consists of?
Can cursors be part of a trigger body?
Is it important to partition hard disk?
How many triggers can be applied on a table?
How to download oracle sql developer?
What is cross join sql?
What do you mean by stored procedures?
what are the nonstandard string types? : Sql dba
Can delete statement be rollbacked?
what is a cursor? : Sql dba
Can variables be used in sql statements?
What is user in sql?
What is sqlerrm?
What are the three forms of normalization?
