Difference between Cluster and Non-cluster index?
- 32 Answers
- 138435 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / p.karthick
clustered index is physically stored
a table can have 1 clustered index
non clustered index is logically stored
a table can have 249 non clustred index
| Is This Answer Correct ? | 193 Yes | 46 No |
Post New Answer View All Answers
What is instead of dml trigger?
How retrieve field names from the table in SQL through JAVA code?
What are the properties of the relational tables?
Mention the differences between having and where clause.
What is bookmark link in ssrs?
What is constraints and its types?
How many types of stored procedures are there in sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
plss anybody specify tha constrian management system in dbms
what is unique and xaml nonclustered index
What are the Advantages of using CTE in sql server?
How to create new table with "create table" statements?
What are subqueries in sql server?
What are the commands used in DCL?
