Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147095 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / rajeev goel
CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.
NON-CLUSTER:- non-cluster like subpart of any part.
for example- content. in side content another subcontent
and so on......
| Is This Answer Correct ? | 24 Yes | 109 No |
Post New Answer View All Answers
Where are full-text indexes stored?
Tell me what is the stuff and how does it differ from the replace function?
Explain the database you used in your final year project?
What is difference between rownum and row_number?
What is the use of keyword with encryption. Create a store procedure with encryption?
What are the filtered indexes?
what is the difference between a primary key and a unique key? : Sql server database administration
What are indexes in sql?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How many types of triggers are there?
what is raid? : Sql server database administration
What is nolock hint in sql server 2008
What is cube dimension? : sql server analysis services, ssas
What is fill factor and pad index?
How to get the definition of a user defined function back?
