Sequential reads vs Direct reads

[Former Member]

Hello gurus,

Could you please let me know what are the main difference between direct reads and sequential reads in terms of performance?

Thanks and best regards,

[Former Member · Accepted solution]

Mainly, Direct Read refers to accesses in which a maximum of one line is returned by the database, otherwise Sequential Read refers to all other read database accesses, in which there may be more than one line returned.

In case of Sequential Read, when you perform a trace on these queries you will see that index is used in most cases. However Direct Read have better performance than Sequential.