Select DFKKOP

Former Member — Mon, 28 Jan 2008 09:41:07 GMT

Hi guru's,

I am performing a select on table DFKKOP and am wondering if there is performance to gain.

I only have a list of bussiness partners.

* Get entire balance for these business partners
  SELECT augst gpart budat betrw augdt augrd
    FROM dfkkop
    INTO TABLE gt_dfkkop
    WHERE vkont NE space
      AND gpart IN so_gpart
      AND stakz EQ space
      %_HINTS ORACLE 'INDEX("VKONT" "GPART")'.

Is there anything I can do to let it perform even better?

regards,

Wim

Re: Select DFKKOP

Former Member — Mon, 28 Jan 2008 14:50:05 GMT

You are not using any index for this SELECT and that will hurt performance the most. And I don't think that Oracle can evaluate the hint you are giving it.

Rob

topic Select DFKKOP in Application Development and Automation Discussions

Select DFKKOP

Re: Select DFKKOP