| |
GeekInterview.com > Interview Questions > Database
| Print | |
Question: What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger?
|
| May 05, 2007 00:26:36 |
#5 |
| vibha_kant |
Member Since: May 2007 Total Comments: 5 |
RE: What is the difference between a stored procedure ...
|
Clustered Index:
A clustered index reorders the way data is physically stored in a disc. Thats why there can be only one clustered index on the table. The leaf nodes of the index contains the data pages.
Non-clustered Index:
A non-clustered index is an in which logical order of the index do not match with physical order of data stored. In this case the leaf node do not contains data pages but contains indexed rows. |
| |
Back To Question | |
