Re: tuning problem

You could add an additional column to the table PPOM_STUB, the new column = SUBSTR ( PPOM_STUB.pobject_uid , 1 ,14 )

Then add an index to the column.

That would achieve a similar result as below to force an index scan on PPOM_STUB.pobject_uid

The orginal table would have to become a view (less the extra column) Note: this probably would not be supported by the 3rd party app :)

Test this out. If you can prove to the developers of the 3rd Party app that you will get a big performance improvement, they might implement the change themselves.

Have Fun

--
Posted via http://dbforums.com