Bentley Systems interview question

How would you improve a select query in MS SQL server