Hi, I'm having one query which is more frequntly access by user. select id, lname from godev.user where upper(sepr)='Y' This tables have 711180 rows out of 27 rows are having sepr equal to 'Y'. select mda_id, lname from mangodev.mdanywhereuser where hopkinsepr='Y' Which query would be fast if sepr didn't have any indexes? thanks _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar ? get it now! http://toolbar.msn.com/go/onm00200415ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------