Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 8053 Views
- Standard Bank, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / nagabhushan
Indexes are of two types,Clustered Index and non Clustered
Index,when you create Clustee index on tables all the rows
in the tables are stored in the order of the clustered
Index key,So there will one cluster index in the table.Non
Clustered Index have there own storage seperate from the
table data storage.Non Clustered Index is stored in the
form of B-trees.
| Is This Answer Correct ? | 8 Yes | 1 No |
find 2nd highest salary of person using cursor concept?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Is there any difference between the primary key and unique key?
What is an index. What are the types?
Can you force a query to use a specific index?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Does table partitioning improve performance?
Explain about analysis services?
How to use “drop” keyword in sql server and give an example?
What is the difference between having clause and where clause in sql server?
What type of locking occurs during the snapshot generation? : sql server replication
How to Check if table exists in sql server?
-
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)
