QTP reads every row instead of using index?

[Arnold Chan]

Hello,

We're running PH 8.40d with Oracle8i (really) on OpenVMS. We have a problem with QTP. It correctly applies the SELECT criteria but it does so by reading every row in the table instead of using the index. Unfortunately something I can't get SET LIST SQL to show anything either. Here is my test results are below. I have a index on the bcsapfos_id column but it insists on reading every row. Its not a problem in my test data with 643 rows but the production table is much larger.

The index couldn't be more straightforward. I tried using a plain b-tree index too. It did not make a difference.
CREATE BITMAP INDEX con8_idx2 ON con8 (bcsapfos_id);

Any assistance would be *greatly* appreciated.

Regards,
Arnold Chan,
Registrar's Office,
Camosun College


> RUN ECE_TEST
> REQUEST ECE_TEST1
> ACCESS CON8 IN IFAS_DB
> SET LIST SQL
> SELECT CON8 IF (BCSAPFOS_ID = "XDG1")
> output con8 in ifas_db update
> item bcsapfos_id = "XDG1"
> GO
Executing request ECE_TEST1 ...
Records read:
  CON8                          643
Transactions processed:           4
Records processed:            Added    Updated  Unchanged    Deleted
  CON8                            0          0          4          0
Finished.

---