topic Re: Select single vs Select count in Application Development and Automation Discussions

Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:02:37 GMT

Hi Team,

Please suggest me the best practice.

If I have to validate a field from DB.

Which stmt is preffered. Is it Select Single or Select Count.

Note : Target - Just to check if the record is exists in DB.

Please suggest the best way.

Thanks in Advance.

Ravindar.

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:05:23 GMT

Use Select Single using all the table keys...

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:06:10 GMT

hi,

Use select up to 1 rows,bcoz

select single shoul be used if u are comparing all key fields in the query else u have to use select up to 1 rows.

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:07:24 GMT

select single from <table>

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:08:10 GMT

Hi Ravindar,

Search the SCN before posting the basic question. You can find lot of treads for your query.

Reported!!!

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:08:30 GMT

hi,

Using select up to 1 row is better way than the select single,

because select single hits the database more than once , where select up to 1 row hits only once in your program, hence a performance improver.

Thanks and regards

Sharath

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:09:33 GMT

Hi,

It depends on your specified where clause.

If you are specifying full key part in where condition , then it is better to use SELECT SINGLE.

Regards

Pinaki

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:11:14 GMT

Hi,

Select Single will take only one matching record from the database and stores inot buffer.

Select upto 1 rows will take all the records which are matching to that condition into the buffer.

so performance wise select upto 1 row is better than select single.

Regards,

jaya

Re: Select single vs Select count

Former Member — Fri, 13 Feb 2009 07:19:15 GMT

done