Select * with CRMV_LINKORGMAN giving better performance than Select Single*

[Former Member]

Hi,

As in my Subject line, I am not bale to comprehend the reason. On what base should I suggest the developers to make the changes in code. I have analysed it in SE30.

Select Single * took 19.450.230.000 microseconds.

select * took 713.955 microseconds seconds.

CRMV_LINKORGMAN is view, as you might know.

Regards,

Chitwanjit

[former_member182566]

Hello.

Have you tried executing more than once?

Have you tried executing them in the opposite sequence (SELECT * first) ? (the first one you measure will often be slower)

What is your complete select?

Regards,

Rui Dantas

[Former Member]

Here is the complete select.

data itab type standard table of CRMV_LINKORGMAN.

data wa_link type CRMV_LINKORGMAN.

select * from CRMV_LINKORGMAN INTO table itab

where SALES_ORG = 'O 50002332' .

[former_member182566]

And have you tried executing more than once, and executing them in the opposite sequence (SELECT * first) ?

[former_member182114]

Hi Chitwanjit,

Probably you are not using the fully primary key to use the SINGLE instruction (it work's but it wasn't designed for retrieve one THE record, for this the where clause must reach a unique index).

Since this is a view, this uniquecy must be checked according the database union on view.

BTW: Please answer Rui's question, it's important for understanding caching.

Regards, Fernando Da Ró

[Former Member]

Yes,

I have tried in diff sequence and tried more than once. I think the point made earlier that Primary keys are not included in the where clause, make it perform in the current manner. Anyhow, The View is using two very huge tables and I have decided to replace the same with the JOIN on two tables which has given marked improvement in performance.