Link to home
Start Free TrialLog in
Avatar of MIHIR KAR
MIHIR KARFlag for India

asked on

Oracle_Hints

Hi Expert,

Can anyone please explain the below mention hints in select stmnt and how does this works internally (CPU and processor ).

 SELECT /*+ PARALLEL(16) USE_HASH(VLL, US) USE_HASH(VLL, DUL) USE_HASH(VLL,SUL) USE_HASH (UI, VLL) USE_HASH(VLL, UDOD) PQ_DISTRIBUTE(VLL, HASH, HASH) */
         DISTINCT
                   vll.item item,
                   vll.source source,
                   vll.dest dest,
                   ---0 aprfl, Commented for CR#102373

Tables Ex::  FROM
                   stsc.vehicleloadline vll,
                   stsc.udt_loc dul,
                   stsc.udt_loc sul,
                   stsc.udt_item ui,
                   stsc.udt_sku us,
                   STSC.UDT_VEND_PACK_DC vpd

Thanks In Advance .
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MIHIR KAR

ASKER

Thank You!!