Several ideas for improving database query speed and several ideas for database query

Several ideas for improving database query speed and several ideas for database query
Several ideas for improving database query speed:
1. Caching: caching on the persistence layer or persistence layer;
2. Remove large fields from the database table to ensure that the data volume of a single record is small;
3. Use indexes appropriately;
4. Create a multi-level index if necessary;
5. Analyze the execution plan of Oracle and assist the database in the correct query mode through the data statistics of tables. The index should be taken as the index, and the full table scan should be performed as the full table scan;
6. Table Partitioning and sharding, whether it is business logic splitting (for example, one report per month, database sharding) or a partition without business meaning (for example, mod-based partition based on ID );
7. RAC;
8. Redundant fields to reduce cross-database queries and large table join operations;
9. Data is generated by one or more jobs to reduce real-time queries;
10. From the disk, data is stored on the internal and external magnetic channels of the disk, and the data acquisition efficiency is different;
11. discard some features of relational databases and introduce NoSQL databases;

12. Use another method to store data, for example, inverted table in the search;

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.