please start a new thread with a new problem

Please post the ddl for both tables and all indices on them and the plan for
the query

>From: "Bisma J" <bisma@...>

>The query execution took 18.22 seconds! For table "student_biodata", the
>primary key is "student_id". And for table "student_selection", the primary
>keys are "student_id" and "priority".

_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger