Originally posted by fossil
Hi,

2. For joining large tables (million's of rows) you don't
need an index on any column in the where clause.

3. Multi table query will join the tables first and then
filter the rows according to the where clause. You should
not be having an index lookup for the filter.
quite wrong indeed!

I suggest you try dbms_xplan.display in 9i and you will see how predicates are applied before join to reduce the result set! (of course this is not always the case but when the index is selective this will be)