by: pgsql-performance-ow...@postgresql.org
04/07/2010 09:12 AM
To
Sherry CTR Zhu/AWA/CNTR/f...@faa
cc
Joel Jacobson , pgsql-performance@postgresql.org,
Robert Haas
Subject
Re: [PERFORM] LIMIT causes planner to do Index Scan using a less optimal
index
2010/4/7
Do you mean one index on
Do you mean one index on two columns?
something like this: create index idx1 on tb1(col1, col2);
Thanks much!
Xuefeng Zhu (Sherry)
Crown Consulting Inc. -- Oracle DBA
AIM Lab Data Team
(703) 925-3192
Grzegorz Jaśkiewicz
04/07/2010 08:51 AM
To
Sherry CTR Zhu/AWA/CNTR/f...@faa
cc
Joel
Inc. -- Oracle DBA
AIM Lab Data Team
(703) 925-3192
Joel Jacobson
04/06/2010 06:30 PM
To
Sherry CTR Zhu/AWA/CNTR/f...@faa, pgsql-performance@postgresql.org
cc
Robert Haas
Subject
Re: [PERFORM] LIMIT causes planner to do Index Scan using a less optimal
index
Actually, swapping the
