SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 334 Page Views: 

Usually clustered and non-clustered indexes are discussed. It can be further configured into three categories. Which are those?



Posted By: Avi Date: 1 October 2010 11:11:07 AM
 Answer:

The three ways other than clustered and non-clustered it can be configured into Composite Index and Unique Index. Composite index:- It is an index that contains more than one column. Both clustered and non-clustered indexes can exist as composite index. Unique Index:- It is an index which maintain the uniqueness of the value of the index table. The unique index is created automatically as soon as Primary Key or Unique key is defined in a table. Covering Index:- It is an index which contains all the coulmns which are required to run a query. For eg. The query retrieves the Student Name and its marks column form the table based on the value of columns Class and roll number. Then we can create a covering index having all these 4 columns.


Posted By: avibtech

Date: 1 October 2010 11:11:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image aFg8hb
Related Questions
SQL Server : Can a stored procedure have optional parameters?

Can a stored procedure have optional parameters?

Yes, a stored procedure can have optional parameters. With the help of default value for the optiona....
Category: SQL Server Date: 10/1/2010 11:20:07 AM
SQL Server : Can you tell the important features of sub-queries?

Can you tell the important features of sub-queries?

Subqueries are very beneficial if used properly.They allow to return the desired result in a single ....
Category: SQL Server Date: 10/1/2010 11:19:07 AM
SQL Server : What are DDL statements? Name some DDL Statements?

What are DDL statements? Name some DDL Statements?

DDL statements mean Data Definition Language statements. This the vocabulary used to define the data....
Category: SQL Server Date: 10/1/2010 11:18:07 AM
SQL Server : Does the order of columns matter while creating a table? i.e which coulms should come first and which last according to constraints and values?
SQL Server : Having the following table:- sno val1 1 7.5 2 8 3 9.5 4 11 . . . N val Write the code to update the table where the difference in the column "val1" is computed i.e. (val1[2]-val1[1

Having the following table:- sno val1 1 7.5 2 8 3 9....

Code Required is:- update cal set diff_val = 0 where ID = (select min(sno) from cal) Update cal ....
Category: SQL Server Date: 10/1/2010 11:16:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories