use_hash in derived table
Is it possible to use use_hash in the derived table?
I get a warning "Each calculated column must have an explicit name" if I include
select /*+ use_hash(table_names) */.It parses ok if I remove this line.Basically query runs for a long time without use_hash.
Can somebody help me with this?