what is the use of database index(apart from the last
searching of records) and what is the use of composite key?
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
List some advantages and disadvantages of stored procedure?
What happens if the update subquery returns multiple rows in ms sql server?
What is a view in sql?
How does recursive cte works in sql server?
What happens if you delete a table that is used by a view?
Explain table valued parameters in sql server? Why tvp used?
What is sql azure database?
How to see the event list of an existing trigger using sys.trigger_events?
Tell me what is normalization? Explain different forms of normalization?
how we use window authentication connection with sql server.?
How to create sub reports?
What causes index fragmentation?
How to modify the underlying query of an existing view?
What is sql server transaction log file?
Write a sql query to get zero records from a table having n number of records?