Thanks for your valuable response.
NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_COL_PLUS_SHOW_PARAM
---------------------------------------------------------------- ----------- ----------------------------
filesystemio_options string none

The query is tuned. It is using the correct index (Rebuilt on request from metalink during our analysis yesterday)