by GArlington <garlington@[EMAIL PROTECTED]
>
Feb 20, 2008 at 04:05 AM
On Feb 20, 6:46 am, m <mod...@[EMAIL PROTECTED]
> 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
You can select any single field from your record
i.e. select col1 from tablex where col1=5 and col2='a'
