Questions tagged [optimizer-hints]
36 questions
0
votes
2 answers
Hint FIRST_ROWS(n) not giving optimized result for Order by clause
We have around 8 million records in a table having around 50 columns, we need to see few records very quickly so we are using FIRST_ROWS(10) hint for this purpose and its working amazingly fast.
SELECT /*+ FIRST_ROWS(10) */ ABC.view_ABC.ID,…
emarshah
- 328
- 3
- 14
0
votes
1 answer
Optimize two simple nested loops
I have been trying to optimize the two following nested loops:
def startbars(query_name, commodity_name):
global h_list
nc, s, h_list = [], {}, {}
query = """ SELECT wbcode, Year, """+query_name+"""
FROM innovotable…
relima
- 3,462
- 5
- 34
- 53
0
votes
0 answers
How to force oracle to use index or ordered hints for remote joins
I'm using Oracle 11g. I have a query that joins local table with remote tables using db links. I want the driving table to be the remote table as I primarily filter using remote table to get a few rows. I then want to join them with local table.
The…
Vijay Jagdale
- 2,321
- 2
- 18
- 16
0
votes
1 answer
oracle hint over several joins with different methods
I'm trying to force the oracle database 11g express edition to make the JOINs with two specific methods in a two JOINs SELECT, but it's not working when I try to do it with the USE_MERGE and the USE_NL hints. My SELECT looks like this:
SELECT /*+…
0
votes
3 answers
Is there a oracle hint to execute the where clauses in a specific order?
Consider the following two queries on a table where datecolumn is indexed -
Q1: select * from table where datecolumn > sysdate - 5;
Q2: select * from table where datecolumn > sysdate - 5 and datecolumn < sysdate - 1;
Q1 uses the index. But, Q2…
trinity
- 10,394
- 15
- 49
- 67
-1
votes
1 answer
Netbeans codehints for generated code
Recently my NetBeans show me a ton of yellow hints for code, that is auto-generate by NetBeans itself when creating GUI for me. Is there a way, how to get rid of it, because I obviously cannot just simple change auto-generated code.
I assume there…
Ellrohir
- 1,017
- 1
- 14
- 32