A Where clause in your SQL and indexes that support the Where clause are a good place to start.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Hi
How to avoid FULL TABLE SCAN?
Thx
-seema