Secondary index with decimal field

[Former Member]

Hi all,

I am having a problem with standard secondary indexes that contains decimal fields.

If i search for the exactly match, it uses the index, but if i use a range, or a comparative like < or > it doesn't use the index.

I checked with other SAP instalation that has Oracle and it works fine with the range and comparatives.

Does anyone know how can I fix this problem?

Is this a database problem?

I will be very gratefull if you can help me.

Regards,

Nicolás.-

[former_member524429]

Hi,

Optimizer Statistic for that affected Index/table is Up-to-Date ?

If it is not the latest, then first Update Optimizer statistic for the Table/Index by executing RSANAORA report (in SE38) with "Compute Statistic" method.

After Updating Table/Index Optimizer statistic, try to execute the same queries/report and analyze its executing behavior.

Also update Oracle Dictionary & System Statistic of the Database on monthly basis using DB20 -> Global.

Regards,

Bhavik G. Shroff

[Former Member]

Hi Bhavik,

Thanks for your reply, i tried to execute the report RSANAORA:

Error: analyze table "CRMD_ORDERADM_H" compute statistics ; failed with ORA-170

I don't have Oracle, our DB system is MSSQL.

Do you have any thoughts about this?

Regards,

Nicolás.-

[former_member524429]

Hi,

OOPS..sorry .. I overlooked ur post. The last given suggestions only works for ORACLE database.

You can use DB02 to update Optimizer Statistics for Table/Index.

or

Alternatively you can execute this command UDATE STATISTICS <table name> WITH FULLSCAN to update optimizer statistic.

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Nov 24, 2010 6:15 PM