Difference between Cluster and Non-cluster index?
Answer Posted / jagan
Clustered Index:- It reorder the table phyically and stores
data in a DATA PAGE. DATA PAGE is nothing but page contains
all the data in correct order.Indexing is known as index in
a book(titles with page number).It helps the SQL SERVER to
retrive the data quickly and make the query to perform
fastly.Only 1 index for a table.
Non Clustered Index:- Index that is created in any order.
we can create up to 249 in a table.Indexing is known as
index in a book(titles with page number). performance will
be little bit less than the clustered index.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is partition index in sql server?
What is raiseerror? What is raiseerror?
How to insert data into an existing table?
What are commonly used odbc functions in php?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What happens when unicode strings concatenate with non-unicode strings?
What is the purpose of the tempdb database?
How many types of schemas are there?
What is an execution plan? When would you use it?
Write a SQL command to insert and update only a particular field?
What is side by side migration in sql server?
Explain concepts of analysis services?
What command do we use to rename a database?
What are the key configuration files for sql server reporting services ?