MIHIR KAR
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 .
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER