Aug 162013
 
select *
from   joins
where  cost > 'more than you budgeted for';

DESCRIPTION
---------------------------------------------
An unindexed merge join of million row tables
Getting married

While these can both last a lifetime, only one is supposed to! ;)

  3 Responses to “Expensive Joins”

  1. I would expect a and

    ORA-01013: user requested cancel of current operation

    in both cases ?

  2. […] If there’s no indexes on the column(s) joined in a query then this is going to lead to a full table scan of at least one of the tables. If both of these tables are “large”, this is going to be expensive. […]

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)