Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146985 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ghanshyam vishwakarma
CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.
NON CLUSTERED INDEX:
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a unique key constraint?
what is bit datatype? : Sql server database administration
How to see the event list of an existing trigger using sys.trigger_events?
What is federation member?
How do you use a subquery to find records that exist in one table and do not exist in another?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What are different types of join?
What is format parameter in ssrs?
Can we write a distributed query and get some data which is located on other server and oracle database?
What is the use of for clause?
Is t sql the same as sql server?
What is the purpose of the tempdb database?
How to create a stored procedure with a statement block in ms sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
Explain about service Broker functions?
