Originally posted by rshivagami
How does the usage of the column COMPLETED_DATE of table CLG_ASSESSMENT_RESULT affect the usage of the PrimaryKey on CLG_STANDARD ? There is no relation or no constraint between them whatsoever
There is ofcourse a relation, not direct though, that what number of rows (to be specific blocks) will be filtered with and without COMPLETED_DATE & that inturn affecting the amount to joining required..

Abhay.