Re: Selecting row from a table

m wrote:

> Hi All
> 
> I have a table with nearly 10,000 rows and 50 columns.
> 
> I have a select query like
> select * from tablex where col1=5 and col2='a'
> 
> I run this from my java program using jdbc.
> All I am interested is if there is match or not.
> 
> Is there a better way to write the query instead of saying "select *"
> I am thinking select * might take more time.
> 
> Please let me know.
> 
> Thanks

Someone once mentioned a query like this:

select 1 from table where col=val

Or, if that doesn't work, do a 

select count(*) from table where col=val

which gives you the number of rows with the condition.
-- 
Sabine Dinis Blochberger

Op3racional
www.op3racional.eu