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
- 4903 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 |
Can two different columns be merged into single column? Show practically?
What is nolock?
How to connect to a sql server using odbc_connect()?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What happens if null values are involved in comparison operations?
What are the mathematical functions supported by sql server 2005?
What is sql injection and why is it a problem? : sql server security
Why use “in” clause in sql server?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
Where are sql server user names and passwords stored in sql server?
What is replace and stuff function in sql server?
How do you clear a log file?
-
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)
