Teachers would like to ask A question, A table is A B C D multiple tables together business table, the table is A large amount of data, real-time business use A table in the query, I want to delete this table and insert to ensure transaction agreement isn't there A blank period, this time on and query optimization to do

CodePudding user response:

If only the query, can consider to build the view

CodePudding user response:

reference 1st floor u012355452 response:

if only query, can consider to build the view

view query efficiency is low? This form must level data

CodePudding user response:

refer to the second floor qq_39453761 response:

Quote: refer to 1st floor u012355452 response:

If only the query, you can consider to build the view

view query efficiency is low? This form must level data

All queries, slow business queries are conditional, appropriate index efficiency is not too bad,