Originally posted by jmodic
Originally posted by farrokhp
Is this stat correct ??

If joining of tables is used frequently, consider Composite Indexes.
Generaly speaking, that statement is a nonsence.
Yes it is. Somebody might ask why. When a composite index on the larger table of a join does not include the join condition as the leading part of the index, then that index on the subsequent part of the query must be forced or Oracle will perform a full table scan on all tables.