Re: Full Table Scan

From: Neil Greene replace dev.null with laoc.SHL.com <ngreene_at_dev.null>
Date: 1998/01/27
Message-ID: <MPG.f36e6a7ad55ce2a9896c9@news.internetmci.com>#1/1

Steven R Fuller wrote....
> HELP-
>
> I have created the following sql select statement, unfortualty when I runit
> I get multiple full table scan's, How can I eliminate this with out altering
> my select statement.
>

[ Select statement removed ]

Ummmmmm, an explain plan would be useful. --- Neil

-- 
Neil Greene			Technical Architect / Oracle DBA	
MCI Systemhouse, Inc. 		

Email:		<mailto:ngreene_at_laoc.SHL.com>			
Pager Email:	4112636_at_PageMCI.com		Pager:	800-411-2636

Received on Tue Jan 27 1998 - 00:00:00 CST