========
Stats are on.

Computed, with histograms for indexed columns. Indexes also coalesced - and where significant free-space generated, rebuilt.

The thing I was going to mention earlier (but forgot), most SELECTS are done via views that have IN-lists within the code. This is outside vendor programming which we are stuck with for the present.

=======

Use 10053 events to trace the SQL that has IN-lists. You will know why the optimizer chooses FTS. Or you post the trace here. We will examine.

Tamil