Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of database index(apart from the last
searching of records) and what is the use of composite key?
- 1 Answers
- 3593 Views
- I also Faced
- E-Mail Answers
Answer Posted / brijesh kumar
Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table
Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is the optimization being performed in oracle and SQL Server?
Explain error and transaction handling in sql server?
How to compare the top two records using sql?
Explain tablesample?
Can we insert data into a view?
What is bcp? When does it use?
What are different types of collation sensitivity?
What does select 1 mean?
Explain why variables called the most powerful component of ssis?
How to recompile stored procedure at run time?
What is triggers and stored procedures?
What are the 3 types of schema?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Explain indexed views and partitioned view with their syntax.
Can foreign key be deleted?
