Please just let me know if Postgres can do this kind of index or not. create index idx1 on tb1(col1, col2)
Then later we can find it is useful or useless. Thanks much! Xuefeng Zhu (Sherry) Crown Consulting Inc. -- Oracle DBA AIM Lab Data Team (703) 925-3192 Grzegorz Jaśkiewicz <[email protected]> Sent by: [email protected] 04/07/2010 09:12 AM To Sherry CTR Zhu/AWA/CNTR/f...@faa cc Joel Jacobson <[email protected]>, [email protected], Robert Haas <[email protected]> Subject Re: [PERFORM] LIMIT causes planner to do Index Scan using a less optimal index 2010/4/7 <[email protected]> Do you mean one index on two columns? something like this: create index idx1 on tb1(col1, col2); yup :) It would be quite useless without that feature. Don't listen to oracle folks, they obviously know not much about products others than oracle db(s). -- GJ
