Interested to Buy Any Domain ? << Click Here >> for more details...
What are indexes in sql?
- 1 Answers
- 1289 Views
- I also Faced
- E-Mail Answers
Answer / guest
Indexes improve database performance by allowing faster retrieval of records.
Types of indexes:
• Clustered Index – Reorders table records for faster access.
• Non-Clustered Index – Stores index separately for faster lookups.
• Unique Index – Ensures all values in a column are unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How to view existing indexes on an given table using sp_help?
How exceptions can be handled in sql server programming?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What is indexed view?
How to configure and test odbc dsn settings?
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
What is the difference between insensitive and scroll cursor?
Define master database?
What is the difference between seek predicate and predicate?
How can you list all the columns in a database?
What are the different editions available in sql server 2000?
-
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)
