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
- 3693 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
What is the datatype of rowid?
What is the significance of master, tempdb and model databases?
Why is replication required on the sql server?
Explain microsoft sql server functions?
What is report snapshot in ssrs?
You want to implement the one-to-many relationship while designing tables. How would you do it?
How can i Relate Tables in SSIS
What is query parameter in ssrs?
System requirements for sql server 2005 express edition?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Mention the 3 ways to get a count of the number of records in a table.
Relational calculus is what type of language?
Can we hide the definition of a stored procedure from a use?
What is normalization according to you and explain its different levels?
What is the difference between executequery () and executeupdate ()?
