topic Re: performance issue while using select single query in Application Development and Automation Discussions

performance issue while using select single query

Former Member — Thu, 26 Jun 2008 15:25:35 GMT

hi all,

While using the select single statment performance getting slow

SELECT SINGLE NODENAME

INTO W_CUST

FROM /BI0/HCUSTOMER

WHERE NODEID = W_CUSTOMER-PARENTID.

in where condition given field is secondary key(PARENTID)

This table Technical setting given below

1. data class --customer data class

2. size category --4(expected data record 13.000 to 520.000

but at present my table number of entries (1.544.092)

3. buffering switched on

4. buffer type generic ( no.of key fields 2)

note my tabel has 10 fields in it 3 primary key fields and one secondary fields(PARENTID),

please give me solution to increase the performance

reward asured

with regards,

Thambe

Re: performance issue while using select single query

former_member195698 — Thu, 26 Jun 2008 15:29:38 GMT

create secondary index on field NODEID for the table

Re: performance issue while using select single query

valter_oliveira — Thu, 26 Jun 2008 15:29:45 GMT

Hello.

Run ST05 to check which index is being used.

Are you saying that you created an index for field PARENTID? In that query it won't help. You should create a secondary index with NODEID field.

Regards.

Valter Oliveira.

Re: performance issue while using select single query

Former Member — Fri, 27 Jun 2008 04:21:09 GMT

Hi,

Whenerver You Use

SELECT SINGLE Statement ,In The WHERE Condition

you should use Only the PRIMERY KEYS/KEY FILELDS .

In your code you are not using key fields thats why perfomance

getting slow.

Thanks.

Re: performance issue while using select single query

Former Member — Fri, 27 Jun 2008 06:20:09 GMT

HI,

NODEID is primary key fields field only...

with regards,

Thambe

Re: performance issue while using select single query

Former Member — Fri, 27 Jun 2008 06:27:07 GMT

hi,

Try your query with

SELECT f ... FROM tab UP TO 1 ROWS

It will help you in performance issue.

Anirban Bhattacharjee

Re: performance issue while using select single query

SujeetMishra — Fri, 27 Jun 2008 06:58:00 GMT

hi ,

you can try this

select single xyz

into wa_x-xyz from x_table

and see in ST05 that your selection is using which Index.

If above doesnt work then create secondary Index for ur field.

reward points if this helps........

Re: performance issue while using select single query

Former Member — Sat, 28 Jun 2008 05:00:13 GMT

Hi,

You have said that table have 3 primery key fields.

But in SELECT Query you are using only one primery key.

In Database table For The three primery key combination there is one record.

But for a particuler single primary key there may be multiple records. But in select statement you are fetching single record.

Thats why execution taking more time.

Regards,

sujit

Re: performance issue while using select single query

Former Member — Sat, 28 Jun 2008 05:40:04 GMT

Hi,

The purpose of using the below statement is to pick the exact record without having an impact on the performance .

When using the query Select Single *,

1) It is important to make use of primary key fields in the 'Where clause'.

2) The sequence of the Key field in the 'Where Clause' should be same as defined in the Table. It would have an considerable impact on the performance if the sequence of key fields does not match the sequence defined in the std table.

Regards

Kiran Kumar V