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
- 4900 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 |
How to reaname table name without using sp_Rename in sql server..?
Can you explain what are various ways to enhance the ssrs report?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are acid properties of transaction?
How do I find the transaction log size in sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Do comments need to go in a special place in sql server 2005?
Can you have a nested transaction?
How to write a query with a right outer join in ms sql server?
what is a self join? Explain it with an example? : Sql server database administration
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
-
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)
