The following description of the database SQL optimization method. which is wrong? Single selection
A.
Use paginated query to avoid throughput of full data at one time, and can use 15 data network traffic
B.
B-Tree index reduces the operation of the hard disk by 10 according to the query conditions to improve the query efficiency
C.
Reduce large-scale transaction operations in the business, avoid processing too much data in one transaction, remove unnecessary queries, try to ensure that all read operations are necessary in transactions, and reduce the amount of locked data
D.
Appropriately increase the cache capacity, increase the cache hit ratio, and reduce the load of the hard disk 10
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit