![SELECT TOP 1 from a very large table on an index column is very slow, but not with reverse order ("desc") - Database Administrators Stack Exchange SELECT TOP 1 from a very large table on an index column is very slow, but not with reverse order ("desc") - Database Administrators Stack Exchange](https://i.stack.imgur.com/LH8B3.png)
SELECT TOP 1 from a very large table on an index column is very slow, but not with reverse order ("desc") - Database Administrators Stack Exchange
![SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/unionall.gif)
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave
![How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com](http://dev.mytechmantra.com/wp-content/uploads/2019/07/How-to-Change-Select-Top-1000-Rows-and-Edit-Top-200-Rows-Default-Value-in-SQL-Server-Management-Studio.png)
How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio - MyTechMantra.com
![Cláusula superior en SQL Server con ejemplos (Base de datos) | Consejos e información útil sobre diseño web y desarrollo web! Cláusula superior en SQL Server con ejemplos (Base de datos) | Consejos e información útil sobre diseño web y desarrollo web!](https://lesptitesaffairesdemayl.be/img/images/top-clause-in-sql-server-with-examples_3.png)
Cláusula superior en SQL Server con ejemplos (Base de datos) | Consejos e información útil sobre diseño web y desarrollo web!
![SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2008/03/unionall1.gif)