你即將離開本站

並前往https://www.reddit.com/r/PostgreSQL/comments/lx9yk2/postgres_doesnt_use_index_for_distinct_column/

Postgres doesn't use index for distinct column search and it's ...

select distinct (col1) as col1, col2 as col2 from schema.table where col3 = 'abc' order by col1 desc limit 2;. This is my query.

確定！ 回上一頁

查詢 「PostgreSQL DISTINCT」的人也找了：

  1. PostgreSQL DISTINCT
    2.
  2. PostgreSQL DISTINCT count
    3.
  3. Postgresql distinct order
    4.
  4. Postgresql distinct only one column
    5.
  5. PostgreSQL FILTER
    6.
  6. PostgreSQL GROUP BY
    7.
  7. Postgresql select from (select)
    8.
  8. Postgresql left join distinct
    9.