HELP Tuning SQL statements
From: <huynuye_at_statcan.ca>
Date: 1998/02/13
Message-ID: <887385518.404684804_at_dejanews.com>#1/1
Select * from employees where employee_id = '12345';
will access the table by rowid/ unique index scan on employee_id.
Date: 1998/02/13
Message-ID: <887385518.404684804_at_dejanews.com>#1/1
When I use the EXPLAIN PLAN to view the execution plan for my statement.
The optimizer ignores my index for:
However,
I'm trying to tune an Oracle Web application, and I'm not sure how to use bind variable (eg. :uid). Is there a way to use index for my first statement.
Thanx
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Fri Feb 13 1998 - 00:00:00 CET