About types of indexes in SQL server ?
- 2 Answers
- 6739 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pandian
There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)
| Is This Answer Correct ? | 9 Yes | 3 No |
What is similarity and difference between truncate and delete in sql?
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?
What are the differences between lost updates and uncommitted dependencies?
What are the requirements for sql server 2016?
Explain in brief how sql server enhances scalability of the database system?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is normalization in Database ?
How many partitions a clustered index has by default in sql server 2012?
What is Full Outer Join?
What is a sub-query? When would you use one?
What are the various editions of sql server 2017 that are available in the market?
What is the basic difference between clustered and a non-clustered index?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
