what is the use of database index(apart from the last
searching of records) and what is the use of composite key?
- 1 Answers
- 3218 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
Name the different type of indexes in sql?
What is statement level trigger?
Can we store videos inside the sql server table?
What does asynchronous call backs means?
Explain the advantages of merge replication?
How do indexes help, types?
What is the difference between rank and dense_rank?
What are the properties of the transactions?
Explain indexing and what are the advantages of it?
What is openrowset sql server?
How to concatenate two character strings together?
How do I connect to sql server database?
What is function of ROLLUP ?
Explain what is log shipping?
How to add code to the existing article (using improve article)?
