Many databases are also used for executing dynamically generated SQL queries: OR...

ako on April 22, 2022 | parent | context | favorite | on: How Postgres chooses which index to use for a quer...

Many databases are also used for executing dynamically generated SQL queries: ORM based, or BI/ETL generated queries. If you rely on hints too much, having good statistics is often neglected, and this will impact any query that cannot be provided with hints.