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
- 3671 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
Explain can SSRS reports Cache results?
What are the disadvantages of merge replication?
Explain how dts is used to extract, transform and consolidate data?
Explain aggregate functions?
Is resultset an interface?
How do you identify a foreign key?
Describe in brief system database.
What does executeupdate return?
How to insert new line characters into strings?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are different types of views?
What is 3nf normalization?
Where are sql server usernames and passwords stored in the sql server?
How to use column default values in insert statements in ms sql server?
What type of locking occurs during the snapshot generation? : sql server replication
