Link to home
Start Free TrialLog in
Avatar of ol muser
ol muserFlag for United States of America

asked on

avoiding a full table scan

I have developed a stored procedure and I would like to avoid any full table scans for any of the queries I use. I am able to see the explain plan for the two main queries in the stored procedures and they don't have any "Full table scans" - I don't see the words. And in most cases an index is used. Is this is the right approach to avoid full table scans? What else could be done? I am using Embarcadero Rapid SQL and Sybase.
ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial