Hi Experts... (problem with for do an SQL test)

[Former Member]

Hi people,

I need to do a SQL test in production Environment. I must optimize a SQL statement like "SELECT field_name FROM table_name.". Normally, I'm doing yhis process:

1. I make a Z program, with the SQL statement.

2. I upload the program to Test environment.

3. Finally, I upload the program to Production Environment an Test it.

I understand that this is a long way to do test (I think).

Can someone help me with another idea?

Thanks!

[Former Member]

IN SE30 .

GO in tips and tricks.

You can paste your select query there and analyse the same.

[Former Member]

Hi, thanks U very much, you solved my issue.

Thanks,

P.D: you deserve your ten!.

[ThomasZloch]

This tool is usually not available in change mode in production clients ("changes to ... objects not allowed"), imagine somebody tries to measure the statement "DELETE FROM BSEG WHERE ...".

So better be careful there.

Thomas

[Former Member]

Hi friend,

This question is linked with SQL test issue.

I 've this SQL sentence:

DATA: it_ges LIKE zcctbltar OCCURS 0 WITH HEADER LINE.

CONSTANTS: l_c_si(2) TYPE c VALUE 'SI'.

SELECT z_{mandt z}guid_oportunidad z_{gestor z}tipo1 z~tipo2

z_{tipo3 z}estatus z_{prioridad z}cliente

APPENDING TABLE it_ges_

FROM ( zcctbltar AS z INNER JOIN crmd_orderadm_h AS c

ON z_{guid_oportunidad = c}guid )

WHERE z~tipo2 = 'ZAP'

AND c~zztexto27 = l_c_si.

This sentence needs 6,5 Seconds in INTEGRATION environmet (ZCCTBLTAR have 39.882 items, CRMD_ORDERADM_H have 1.853.334 items).

The problem is that I need do this process more fast than actually. In PRODUCTION environment, We have 3.179.867 items in CRM_ORDERADM_H (double than INTEGRATION).

¿Do U know how optimize this SELECT?

Thanks,

Sergio

[Former Member]

Hi friend,

This question is linked with SQL test issue.

I 've this SQL sentence:

DATA: it_ges LIKE zcctbltar OCCURS 0 WITH HEADER LINE.

CONSTANTS: l_c_si(2) TYPE c VALUE 'SI'.

SELECT z_{mandt z}guid_oportunidad z_{gestor z}tipo1 z~tipo2

z_{tipo3 z}estatus z_{prioridad z}cliente

APPENDING TABLE it_ges_

FROM ( zcctbltar AS z INNER JOIN crmd_orderadm_h AS c

ON z_{guid_oportunidad = c}guid )

WHERE z~tipo2 = 'ZAP'

AND c~zztexto27 = l_c_si.

This sentence needs 6,5 Seconds in INTEGRATION environmet (ZCCTBLTAR have 39.882 items, CRMD_ORDERADM_H have 1.853.334 items).

The problem is that I need do this process more fast than actually. In PRODUCTION environment, We have 3.179.867 items in CRM_ORDERADM_H (double than INTEGRATION).

¿Do U know how optimize this SELECT?

Thanks,

Sergio

[Former Member]

Sergio - since this question is both marked as solved and in the wrong forum, you are unlikely to get a lot of discussion. My advice is to ask it again in the performance and tuning forum.

I should also add that you should include a link back to this thread, so that people can see what was proposed earlier.

Rob

Edited by: Rob Burbank on Mar 30, 2009 2:17 PM

[Former Member]

A better way would be to do this in your QA environment (assuming it is a copy of production).

Rob