|
By Nishant Kumar
What is index? Define its types.
Index
-
Index can be thought as index of the book that is used for fast retrieval of
information.
-
Index uses one or more column index keys and pointers to the record to locate
record.
-
Index is used to speed up query performance.
-
Both exist as B-tree structure.
-
Kind of the indexes are clustered and non-clustered.
|
Clustered index
Clustered index exists as sorted row on disk.
Clustered index re-orders the table record.
Clustered index contains record in the leaf level of the B-tree.
There can be only one Clustered index possible in a table.
Non-clustered
Non-clustered index is the index in which logical order doesn’t match with
physical order of stored data on disk.
Non-clustered index contains index key to the table records in the leaf level.
There can be one or more Non-clustered indexes in a table.
Interview
Questions on SQL Server Replication includes following questions with answers
What is Replication? | What are the types of Replication?
| Define the terms used in Replication. | Describe the replication agents that
SQL Server supports. | Describe in brief working of Replication.
A database is a structured collection of data. Database can be thought as simple
data file......
It is the process of organizing data into related table. To normalize database,
we divide database into tables.....
SQL Server Provides three types of Transact-SQL statements namely DDL, DCL, and
DML....
SQL Profiler is a tool that stores events from the server. SQL Profiler saves
the events in the trace file......
|