Does partitioning help performance?
- 1 Answers
- 1021 Views
- I also Faced
- E-Mail Answers
Answer / Renu
Yes, partitioning helps improve performance in databases by reducing I/O operations and improving query execution speed due to better data distribution.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between 2NF &3NF ?
What are the two types of concurrency?
How to find the login name linked to a given user name?
What are partitioned views and distributed partitioned views?
What is the recovery model?
How do you Implement SSIS Packages in your Project?
Do you know what is xpath?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
List the data types available in mssql?
How do you know if sql server is running on your local system?
How to defragment indexes with alter index ... Reorganize?
Write a query for primary key constraint with identity key word?
-
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)
