Beginners PB, made a data window, written in PL/SQL code that reads field 5 tables, the query speed is 0.5 minutes, consult how to tune?

CodePudding user response:

Related query condition index, according to the index to query, the speed is fast

You can also use database query optimization tools to try

CodePudding user response:

Going to try with the database query optimization tool, read the oracle training materials - SQL tuning, also plans to adjust, choose the most effective form of order, for example, the selection of base table and join order of the where clause,
Thank moderator grant instruction, still hope more tip

CodePudding user response:

Mainly the establishment of the index and query optimization, the data window and the relationship is not big, if the amount of data is very big, best paging

CodePudding user response:

In general is indexed and paging, other also don't know, learn together,

CodePudding user response:

Pb paging how?

CodePudding user response:

Your statement posted, general words or soon
Main index, look at the execution plan, to avoid a full table scan
Avoid using column function

CodePudding user response:

Associated with external connection between tables