Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 8141 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 |
What is the fastest way to permanently delete a 1 million row table named customers?
What are the elements of dbms?
What are the difference between “where” and “having” clause in sql server?
Which are the new data types introduced in sql server 2008?
Do you know the isolation level that sql server support?
What are the ways available in sql server to execute sql statements?
Explain steps of normalization?
How to check if stored procedure is running in sql server?
when you create a database how is it stored? : Sql server database administration
How to perform key word search in tables?
What is candidate key with example?
What is compression - row-level and page-level compression?
-
Oracle (3253) - 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)
