DEV Community

Discussion on: 10x Query Performance with a Database Index

Collapse
 
breachdirectory profile image
BreachDirectory

You should select as few rows as possible - e.g. if you have a table with 1,000,000 rows and your column only has 2,000 and you're selecting data only from that column, your database has less work to do. :)