Interested to Buy Any Domain ? << Click Here >> for more details...
About types of indexes in SQL server ?
- 2 Answers
- 7698 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pandian
There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)
| Is This Answer Correct ? | 9 Yes | 3 No |
define and explain the differences between clustered and non-clustered indexes.
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
syntax for deleting the database in T SQL
What is trigger in salesforce?
How to list all tables having unique constraints in any of the columns in a database.
How would you choose between a clustered and a non-clustered index?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
If a stored procedure is taking a table data type, how it looks?
Explain syntax for viewing, dropping and disabling triggers?
What is an indexing strategy?
How to generate create function script on an existing function?
How make remote connection in database?
-
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)
