index move - now queries are really slow

[Ratzie]

Explain Plan is doing a full table scan instead of using the index, this happens mostly with joins.

How do I set to use the index instead.

[Sandman!]

How about supplying hints to your SQL statement forcing it to pick up the indexes. Other options can be re-writing the SQL to be optimized or creating indexes which will be picked up.

~cheers

[Julio Yamawaki]

Hi,

Can you post the execution plan, table describe and indexes of the table?

Regards,

[Ratzie]

It is long winded but I hope you can decifer it

[Julio Yamawaki · Accepted solution]

Hi,

You see why the query is not using the needed indexes?
Because your fields are nullable.
Nullable fields are not used in a query.
You must change this fields for NOT NULL.

Regards,

[Yogeeraj_1]

hi,

Julio is right.

If you are using CBO, you must not also ignore your table statistics!

select * from user_tables where table_name in ('vt_hist','vt_hist_qlog');

kind regards
yogeeraj

[Ratzie]

Thanks