on 05-27-2011 12:30 PM
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?
As it says, each column must have a unique name.
This is so that you can select it when building objects and predefined conditions.
Please can you post the SQL that you want to use?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.