Interested to Buy Any Domain ? << Click Here >> for more details...
why cluster and non clusterindex are used in sqlserver 2000?
explain with example
- 1 Answers
- 4831 Views
- I also Faced
- E-Mail Answers
Answer / venkat
Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is the maximum row of a size?
Explain user defined views?
Explain about remote stored procedure?
Can you roll back the ddl statement in a trigger?
What is full outer join in sql server joins?
How many joins in sql server?
How do I completely remove sql server instance?
When is update_statistics command used?
What is a data source file?
to explain sql server 2000 architecture & authentication
What are the types of table?
What stored procedure can you use to display the current processes?
-
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)
