Not really sure where to ask this question, as it ...

# exposed

[ron]

Not really sure where to ask this question, as it is Database related I will ask it here. We have a database with a table containing around 8Billion records. When we query this database using intellij and the sql-server driver. the response is usually within 10-20 seconds. If we run exactly the same query, with exactly the same sql-driver on the same development machine the query will take around 14 minutes. Is there any way to "capture" what intellij sends / does with this query.

[hfhbd]

How do you query it inside IntelliJ? By default, IntelliJ only fetches the top 500 results

[ron]

open console, copy paste the query, run the query. We use the same limit

[hfhbd]

If you are using the built in preview, it uses a pagination too