Indexes are lookup tables that when used speed up data retrival within a voluminous table.
I'll appreciate your feedback so I can improve on the sketches.
For further actions, you may consider blocking this person and/or reporting abuse
Read next
SQL: ROW_NUMBER, RANK and DENSE_RANK
Anwar -
ChatWithSQL ā Secure, Schema-Validated Text-to-SQL Python Library, Eliminating Arbitrary Query Risks from LLMs
Sathnindu Kottage -
Linking Data in PostgreSQL Without Explicit Keys: A Practical Guide
JetThoughts Dev -
SQL: Perform statistics at different granularities based on the time span of the data #85
Judy -
Top comments (4)
What happens if there is more than one result?
Good question Giuliovn.
Once a table is indexed based on a column field, a lookup table would be created that references the normal SQL table through the row address column.
So, for example if there are multiple instances of transaction amount, the row address in the lookup table would be pointing to the exact multiple row instance in the transaction table.
Therefore,
Select * from transaction where transactionAmount = 5000
For a multiple resultset won't be a table scan.
Your sketches are awesome and very clear.
Thanks Katie for the feedback:)