topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 10 Aug 2007 11:38:53 GMT

hi to all,

select single *

select to up to n rows

in the above statements which is better in performance.and pls let me know in which constraints tht we can use above statements.

thanx and regards,

loki

Former Member — Fri, 10 Aug 2007 11:40:51 GMT

well you can NOT compare those two.

Select single will get you ONE record only ALWAYS.

while select up to n rown will get you n records if there are enough. otherwise, if there are less than n records it will give you all.

Former Member — Fri, 10 Aug 2007 11:43:07 GMT

Hi Lok

If u know the complete key in where codition use select single

if u dont use upto n rows ( if u have part of key in where condition )

select single is best when u r specifing all key fields in where condition

reward points to all helpful answers

kiran.M

Former Member — Fri, 10 Aug 2007 11:43:15 GMT

SELECT SINGLE IS THE BETTER IN THE PERFORMANCE POINT OF VIEW

SELECT SINGLE ;- IF THERE 100 ENTRIES IN T HAT THERE ONLY ONE CORRESPONDING ELEMENT FOR UR REQ THEN

THIS QUERY WILL SEARCH FOR SINGLE ENTRY HIT AS EARLY AS POSSIBLE IT HITS THAT RECORD IT WILL GIVE OUT PUT

SELECT UP TO N ROWS ;-IT WILL GET THE VALUES UP TO N ROW S

PERFORMANCE POINT OF VIEW SELECT SINGLE IS THE BETTER THAN SELECT UP TO

REWARD IF USEFULL

Former Member — Fri, 10 Aug 2007 11:43:53 GMT

select single *: This helps you to select 1 record....

select to up to n rows: This helps you to select 'n' records,

Depending upon your requirement, you use them ....

Regards,

Pavan

former_member189059 — Fri, 10 Aug 2007 11:44:27 GMT

They both give different output

one returns a table and the other a structure

If you want to know the difference between select single and select up to 1 rows