Hi All,

I know I'm adding fuel to the fire... I have questions concerning RULE and COST Based.

I know that Oracle states that they are phasing out RULE; however, I have seen instances were RULE works much better in 8i than COST on certain applications. Can anyone tell my why this could be a possibiltiy?

Oracle creates a database; however, many different applications work on top of the database. You have Oracle Apps, Sebiel, SAP, PeopleSoft, various CRM packages and COST may not be the best way to go, depending on the application.

Also, I know that development cannot build an application based on COST or RULE, because COST is very dependent on the type of data that is contained in each company's environment.

So, can someone tell me exactly how COST and RULE actually works and if you can actually develop based on either?

Currently, I'm working on an application and I've seen that COST works better for Financials, but RULE works best for the HRMS application?

*First STATS are removed from any TEMP Tables
*Sort Area sizes are low
*DB block size is 8
*Running Parallel processing could decrease performance, instead of improving.
*Partitioning is an additional cost
*Histograms could improve, but if there are bind variables it may not be used.
*Forcing Cursor Sharing, I don't know if it would help.

Any other ideas?

Thanks in advance,
[email protected]