Interested to Buy Any Domain ? << Click Here >> for more details...
How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 8518 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / answerme
Clustered Index are always stored on disk in a certain
order i.e, the data on disk may well be stored in order of
the Primary Key. So the data retreival is faster, when
queried based on Primary key.
non Clustered indexes are all the other indexes on a table,
that do not dictate the order that records are stored on
disk.A non Clustered index stores all the fields that
comprise the index, plus a link to the actual full record
on disk. This link is the primary key (clustered index), so
in fact a non clustered index contains all the columns that
you specify for them plus the clustered index columns too.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is asp.net and its advantages?
What are the differnt types of handler in ASP.NET?
Explain Areas in MVC?
How about the security in Activex DLL and Activex EXE ?
How can u debug your .net application?
What is caching in asp.net?
What is difference between rest and soap?
What is directive in asp net?
If I am developing an application that must accomodate multiple security levels though secure login and my asp.net web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?
Demonstrate Render and PreRender?
Why do you use the app_code folder in asp.net?
Explain the difference between debug.write and trace.write? When should each be used?
a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.
Explain how can we inherit a static variable?
What is razor? : asp.net mvc
