on 10-13-2006 11:19 AM
what is the difference b/w thr direct read and sequential read? Importance of this reads in Expensive sql statements?
direct read: the db-system is able to access the row directly thorugh the specified (primary) key
sequential read: the db-system has to read through the table sequentially to get the result
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
direct read: the db-system is able to access the row directly thorugh the specified (primary) key
sequential read: the db-system has to read through the table sequentially to get the result
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.