You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
- 1 Answers
- 1104 Views
- I also Faced
- E-Mail Answers
Answer / Priyanka Pethe
To improve performance when joining tables with a combination of clustered and non-clustered indexes, you can consider distributing them across multiple filegroups. Clustered indexes should be placed on separate filegroups to reduce the risk of fragmentation and improve read/write performance. Non-clustered indexes should be placed based on their usage patterns (frequently accessed indexes should reside on faster storage devices).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is referential integrity and how is it achieved?
What is forward - only cursors / read only cursor?
What will happen if a column containing char type data is changed to the nchar data type?
which table keeps the locking information? : Sql server administration
Distinguish between commit and rollback?
What is nested transaction?
Explain acid?
Do you know what are the differences between lost updates and uncommitted dependencies?
What are the two virtual tables SQL Server maintains for triggers?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
HOW TO RENAME A COLUMN NAME
How to create a dynamic cursor with the dynamic option?
-
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)
