01-28-2008 9:41 AM
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
01-28-2008 2:50 PM
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