Hi @Jaspreetk6420: What is the volume of data in the mentioned table? Also please check if the column "Status" is indexed in the table. If not, please try creating index on Status column. If it is already indexed, please try rebuilding the index.

Few other options which can be considered as below.

• If the table is storing transactional data and if it is not partitioned, try to partition the table (based on usage)
• Run explain plan of the query which will help to understand where is the issue

Thanks.