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
Timothy Spann. 🇺🇦 -
Franck Pachot -
Once suspended, aloksdiptim will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, aloksdiptim will be able to comment and publish posts again.
Once unpublished, all posts by aloksdiptim will become hidden and only accessible to themselves.
If aloksdiptim is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to alokz diptim!.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag aloksdiptim:
Unflagging aloksdiptim will restore default visibility to their posts.
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.
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:)