Re: Query cost

[Holger Jakobs <holger@xxxxxxxxxx>]

This is difficult to tell because many factors a role. It's best to try it on your machine. Generate data and query them.

Don't forget to optimize your settings. They are far from optimal after installation.

Am 5. November 2020 14:33:54 MEZ schrieb Yambu <hyambu@xxxxxxxxx>:

Hi

What cost is involved in querying a table that has 100k rows versus one that has 20mil rows, and what are the specific advantages in terms of memory,speed etc when a table is smaller?

regards

-- 
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -