I've gotten the plans from Akira Imagawa.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp
> -----Original Message-----
> From: pgsql-hackers-owner@hub.org [mailto:pgsql-hackers-owner@hub.org]On
> Behalf Of Hiroshi Inoue
> Sent: Friday, April 07, 2000 8:39 AM
> To: Tom Lane
> Cc: pgsql-hackers
> Subject: RE: [HACKERS] 7.0 like selectivity
>
>
> > -----Original Message-----
> > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> >
> > "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > > For the query
> > > select hoge_cd,shimeinn,tel
> > > from t_hoge
> > > where shimeinn like 'imag%'
> > > and tel like '012%'
> > > order by hoge_cd
> > > limit 100;
> >
> > > 64 rows returned immediately.
Sort (cost=0.01..0.01 rows=1 width=28) -> Index Scan using t_hoge_ix1 on t_hoge (cost=0.00..0.00 rows=1 wid
th=28)
> >
> > > And for the query
> > > select hoge_cd,shimeinn,tel
> > > from t_hoge
> > > where shimeinn like 'imag%'
> > > and tel like '012-3%'
> > > order by hoge_cd
> > > limit 100;
> >
> > > 24 rows returned after waiting 8 minutes.
Sort (cost=0.01..0.01 rows=1 width=28) -> Index Scan using t_hoge_ix3 on t_hoge (cost=0.00..0.00 rows=1 wid
th=28)
