Effect of Force use of non-existing index in program

[Former Member]

Hi,

What is the Effect of Force use of non-existing index in program?

We have forced the use of a custom index in our program, i want to know the effect in the program if in the future this index will be deleted or removed from the database?

Thanks a lot!

[Former Member]

Hi ,

If an index is deleted or removed from the database then the performance of your report using the

same , will get effected.

May be , performance get poor.

Anyway, Primary index will always be there.( For further clarification you can search the material regarding the same on SDN).

Hope , it helps you.

Thanks

[former_member194613]

> Effect of Force use

what is that ??? how is this done?

An index which is not there can not be used. So the optimizer will use one of the existing indexes.

Siegfried

[former_member192616]

Hi Freishz,

>

> What is the Effect of Force use of non-existing index in program?
> We have forced the use of a custom index in our program, i want to know the effect in the program if in the future this index will be deleted or removed from the database?

Hints note, it is a hint not a command, are ignored by the optimizer if they are not

syntactically and/or semantically correct. An index hint pointing to a non-exisitng index

is semantically not correct -> will be ignored. (A normal costing with the available indexes

is done).

Kind regards,

Hermann