Originally posted by fossil

If you very large tables multi million rows and joinig them then
also FTS will be fastest. Will do the join first, sorts them (if you
have order by) and starts returning rows while filtering.
This is so wrong it must be an april fool's day thing I guess.

You are saying that if I have a 1 billion row table joined to a fifty row table, and I have a predicate on the billion row table that filters out all but one row, then Oracle will ...
  • Join the fifty row table to the 1 billion row table
  • Order the result set
  • Filter the ordered set to remove all but those based on the single row of the billion row table?

There are probably more dumb ways to execute such a query, but this would be way up there on the dumbness scale.