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
- 3761 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 to create an identity column?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Mention the command used to rename the database.
How to insert a new row into a table with "insert into" statements in ms sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How to declare and use cursor variables?
What authentication modes does sql server support?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What are the disadvantages of merge replication?
What is the function of sql server agent windows service?
how can a database be repaired? : Sql server administration
How to rebuild the master database?
List out some of the requirements to set up a sql server failover cluster?
What is temporal table?
How would you choose between a clustered and a non-clustered index?
