Re: Improving performance of this view.
Date: 20 Oct 1994 01:27:20 GMT
Message-ID: <384h1o$lnj_at_fred.uswnvg.com>
Frampton Steve R (3srf_at_qlink.queensu.ca) wrote:
: Hello:
: I have the following view defined:
....deleted....
: from ec_employee emp, ec_employee_positions pos, ec_jobs job
: where emp.employee_id = pos.employee_id
: and pos.emp_group_code not like 'TEMCAS%'
: and pos.emp_group_code not like 'SUPTEAC%'
: and pos.emp_group_code not like 'TMLOA_T'
: and pos.emp_group_code not in ('MARKERS','RETIREES','TRUSTEES')
....deleted....
If you have index on the column "emp_group_code", the "not" stuff above will eliminate the use of those condition in determining which index to use (unless there is another equality or "in" that uses that column).
My suggestion, run "tkprof" or "explain" and see what it does. You may be able to speed it up by making it uses indexes.
Have fun.
Kim Ng
(Just a low life contract programmer. Thus, my clients won't adopt my views.) Received on Thu Oct 20 1994 - 02:27:20 CET