cancel
Showing results for 
Search instead for 
Did you mean: 

what is the difference b/w thr direct read and sequential read?

Former Member
0 Kudos

what is the difference b/w thr direct read and sequential read? Importance of this reads in Expensive sql statements?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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