Hi Team, In our production environment same query is running on two different databases. in one da

Hi Team,

In our production environment same query is running on two different databases. in one databases query running with very low cost in other database it is running with bit high cost .

when i compared execution plan where it is running good for table TASR_CLSOFRQRY it is using AVDB1635 index range scan to pull the database where as in other database same table is using primary key index PK_TASC_CLSOFRQRY01 with index skip scan ,

could you please check the plans attached to SR and let me know how we can avoid index skip scan .

Thanks