RE: 7.0 like selectivity

I've gotten the plans from Akira Imagawa.

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp

> -----Original Message-----
> From: pgsql-hackers-owner(at)hub(dot)org [mailto:pgsql-hackers-owner(at)hub(dot)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(at)sss(dot)pgh(dot)pa(dot)us]
> >
> > "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)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)