do the production and test tables have the same data mass? Have the environment statistics been updated? Could you provide the production and test execution plan with the ddl of the created index and the number of rows in the table?
To make your work easier, you can use Devart tools such as dbForge Studio.