Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of indexes available with SQL Server?
- 2 Answers
- 7928 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 do you understand by a view?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
how to get the rowid/rownumbes of a table in sqlserver
When you first load SQL SERVER you will startup with what all databases?
How is a full-text index updated?
how to delete duplicate rows from table in sql server
12 Answers HCL, UHG,
How do you open a cluster administrator?
How to filter out duplications in the returning rows in ms sql server?
How to update multiple rows with one update statement in ms sql server?
How to concatenate two character strings together?
Explain the purpose of indexes?
What number sorts of privileges are accessible in sql?
-
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)
