Select single vs Select count

[Former Member]

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.

[Former Member]

Use Select Single using all the table keys...

[Former Member]

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.

[Former Member]

select single from <table>

[Former Member]

Hi Ravindar,

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

Reported!!!

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

done