several ideas to improve the speed of database query:
1, cache, on the persistence layer or the persistence layer to do cache;
2, the database table large-scale segment stripping, to ensure that the data of a single record is very small;
3, the proper use of the index;
4, when necessary to establish multi-level index;
5, analysis of Oracle's execution plan, through the table data statistics and other ways to assist the database to get the correct query method, the walk index on the index, the whole table scan to go full table scan;
6. Table partitioning and splitting, whether it is a split on business logic (such as a one-month report, a sub-library) or a partition with no business meaning (for example, partition by ID);
7, RAC;
8, field redundancy, reduce cross-database query and large table connection operation;
9, the data through a single or multiple job generation, reduce real-time query;
10, from the disk on the fuss, the data stored in the disk on the internal and external tracks, the efficiency of data acquisition is not the same;
11. Discard some features of relational database and introduce NoSQL database;
12, different ideas to store data, such as the search in the inverted list;
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Some ideas on how to improve database query speed
