about PurePath of Database

[knakayama]

Hello,

I have a question about PurePath screen.

I want to know the sources from which "Fetches" and "Rows returned" items are obtained.

Also About "Fetches" and "Rows returned" There are places where the value is 0 and blank.

Please tell me if you know about this difference.

Regards,

Kaori Nakayama

[Yosi_Neuman · Accepted solution]

Hi

Here is the explanation for your question from documentation

HTH

Yos

[ChadTurner]

Per the support doc:

The Fetches column shows the number of database round trips per SQL execution. Because most database drivers page result sets, roundtrips are normally fetched in sets of Rows returned per fetch. Therefore, if a result set has 200 rows and you have a fetch size of 50 rows per fetch, it will take 4 fetches to get all the data. More fetches mean slower response time. However, having too large of a fetch size can also lead to poor memory usage and you typically wouldn't read an entire data set anyway.