The station_id_Begin in the event_Range table doesn't have any null
nor is the station_id_end.

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Friday, February 28, 2003 12:01 PM
To: LazyDBA.com Discussion
Subject: Re: RE: question regarding full table scan


forgot about one other thing... do you have any nulls in that column? if you
do, no index.

you can get around that by adding

where col is not null

forgot about that one.


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page