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
- 3701 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
How real and float literal values are rounded?
What is temporary table in sql server? Why we use temp table?
Explain an automatic checkpoint
What are the difference between clustered and a non-clustered index?
Can another user execute your local temporary stored procedures?
What is resultset concur_updatable?
Why use stored procedures in sql server?
Can sql servers linked to other servers?
Can we use custom code in ssrs?
What is difference between count (*) and count 1?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
how can you attach more than 20 ldf files in sql server
How to edit table in sql server 2017?
how many bits ip address consist of? : Sql server database administration
Explain about builtinadministrator?
