Hi
I have a impromptu-report where the execution time is way to long. So I analysed the SQL-Statement. After adding a particular index to it - the execution time is very short:
for example (simplified statement):
with use of a particular index:
Is there a possiblity in Impromptu (I'm using version 7.0) to use a particular index (like in the sql-statement above)?
Thanks in advance!
I have a impromptu-report where the execution time is way to long. So I analysed the SQL-Statement. After adding a particular index to it - the execution time is very short:
for example (simplified statement):
Code:
Select table_a.nr, table_a.name, table_a.date,...
from table_a, table_b
where table_a.nr = table_b.a_nr
and ...
with use of a particular index:
Code:
Select /*+ index(table_a INDEXNAME) */ table_a.nr, table_a.name, table_a.date,...
from table_a, table_b
where table_a.nr = table_b.a_nr
and ...
Is there a possiblity in Impromptu (I'm using version 7.0) to use a particular index (like in the sql-statement above)?
Thanks in advance!