Subject Re: Query plans and joins
Author flipmooooo
Hi Set,

> Are you sure using the index speeds up your query?

It doesn't make the query faster, but the additional sort, which IMHO
means it will have to fetch all rows on the server side before the sort
can be done, (PLAN SORT (JOIN (A NATURAL,B INDEX (PK_TEST_ID)))) after
kills the performance compared to traversing rows using
UC_TEST_DETAIL_CODE_VNR when using an inner join (PLAN JOIN (A ORDER
UC_TEST_DETAIL_CODE_VNR,B INDEX (PK_TEST_ID))). I don't understand why
it can't use UC_TEST_DETAIL_CODE_VNR for ordering when using a left