I have a query that is using `OFFSET X ROWS FETCH NEXT 50 ROWS ONLY`. If X is 160745 it uses the index, if X is 160746 it does not. There are more than 400000 records. With the index, it takes about 2 seconds to run, without the index it takes ~30 seconds. 

We are using Azure S0

I know I can use query hints, however is there another option? Is there something in Azure that I can set to improve this? Any ideas would be appreciated.

\*\*Note: assume all columns are no bigger than `nvarchar(255)` and only 6 columns.

Below is the query:

```
SELECT *
FROM [TableName]
ORDER BY [ColumnName] ASC
OFFSET 456450 ROWS FETCH NEXT 50 ROWS ONLY

```