Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145964 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kenatrivedi
Clustered Index is Clustered Index
Non-cluster Index is Non-cluster
| Is This Answer Correct ? | 61 Yes | 255 No |
Answer / hero
Clustered Index is non-Clustered Index
Clustered Index is Clustered Index
Non-cluster Index is cluster index
| Is This Answer Correct ? | 24 Yes | 244 No |
Define views.
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
What is self contained sub query?
select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?
How does a profiler work?
What is the data type of time?
Explain user defined functions?
Does full backup break log chain?
logshipping is Any difference 2000 and 2005?
What are subquery and its properties?
Do you know data definition language, data control language and data manipulation language?
How to get a list of columns in a view using the "sp_columns" stored procedure?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
