what is the use of database index(apart from the last
searching of records) and what is the use of composite key?
- 1 Answers
- 3822 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 do I start sql server 2017?
List out the different types of locks available in sql server?
what is the difference between openrowset and openquery?
What kind of problems occurs if we do not implement proper locking strategy?
Explain system functions or built-in functions? What are different types of system functions?
When should you use an instead of trigger?
How can we solve concurrency problems?
Disadvantages of the indexes?
What is an indexed view?
Can one drop a column from a table?
How to convert numeric expression data types using the cast() function?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Can sql servers link to other servers like oracle?
How to remove duplicate rows from table except one?
