|Query Paths Ranked in Order of Speed
The lower the rank, the faster the path.
RankPath1ROWID = constant2Unique indexed column = constant3entire
Table Structure for demos
table oe (id number(6,0),
The field id holds the unique reference number starting at 1 the
unique index on id
there are 100,000 rows in oe
table oe_link (oe number(1),name char(10)
with 2 records
table oe_link_name (name char(10),age number(3))
With 1 record
people (name, sex)
Don't perform unnecessary joins.
In some parts of our system, developers are joining onto the sys_param table. This is bad practice and must be stopped. The sys_params table was designed to hold static system wide values.
The correct use of this table, is for the application code to get the values it requires once at the start of the code, or in the case of regular update cycles, at the start of each such cycle.
At the logical level, any runtime modification of sys_params, probably indicates missing entities.
Have a Oracle Question
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.