Information about database reads

[Former Member]

Hi gurus,

i have a small doubt about sapbasis related information

1. what is the difference between logical reads and physical reads

2. what is the difference between direct reads and sequential reads

can u please tell me the answers what i mentioned above if u know

Thanks,

krishna.

Edited by: Juan Reyes on Jul 15, 2008 10:38 AM

[Former Member]

1. logical read: read data from buffer,

physical read: read data from database directly.

2. direct read: just one row in your query result.

sequential read: more than one row in your query result

[Former Member]

Hi expert ,

i got a answer

but i dont get the query result

can u please describe the "query result "

please

ok

Thanks ,

krishna.

[Former Member]

He is talking about SQL query.

Rahul

[JPReyes]

A query result... is the output for a query... simple heeee...

Basically a query is a question asked to the database, for example if you ask the database via an sql command to list all objects in a certain fields it will produce a list, that list is the query result or output.

Regards

Juan

PS: By the way please put proper details on your threads subjects.