Full table scan

How do I read an explain plan? I understand that full table scans are bad, but how do I know what WHERE clause line is at fault? What's the best way to eliminate a full table scan? An index?

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!