The Schema Plays an important role in tuning joins
Choose data types for all primary and unique keys carefully, and remain consistent through out the schema
If you primary key column is varchar2(100), such a primary key is expensive because the large key must be carried in every referencing table, and also because Oracle bust compare long strings when performing a join
Create Index where necessary and if possible try to create indexes on multiple columns
Normalize your tables , so that there is not a lot of redundancy
Put necessary constraints on the table so that you have the right data.
Statistics are used by the optimizer to come up with a good execution plan
Sometimes optimizer statistics might be stale or missing
The statistics may not always be accurate because the size of the table might have changed from a few 100k rows to a few million rows. There fore statistics should be periodically collected and be made as part of the database maintenance routines.
Because of the Lord, each of his messenger succeeds and By His word all things hold together. We could say mmore but could never say enough..... let the final word be "HE IS THE ALL" -Ecclesieasticus 43:26-27
We got top quality weed available for sale both locally and internationally.... Here is a list of my best selling strains sour Diesel black domina Gorilla glue OG Kush granddaddy Super Skunk Gril scout cookies you can contact me (303) 569-9463 for more details and to place your order.