Answer Posted / sanjay mukati
Index is a such type of mechanism in which records are
searched and fetched efficiently and fastly in a table. It
is physical address of data.
Two type of index :
A. Cluster Index
B. Noncluster Index
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
what are the three command line utilities and what are their primary functions?
How many categories of functions based their return modes?
Name 3 ways to get an accurate count of the number of records in a table?
How to loop through returning rows?
What are database states in ms sql server?
How do you handle datasets larger than 50 gb?
What is the contrast between sql and pl/sql?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are click through reports?
What is difference between index seek vs. Index scan?
Explain go command in sql server?
What is Federation Root Database?
Explain what is row_number function?
What do you think of this implementation? Can this be implemented better?
Explain different types of index?