Am Freitag, 25. Februar 2005 17:31 schrieb Dave Smith: > I am using 7.4.5 and trying to use the like clause (Local C) but > postgres does not seem to want to use the index. > > explain > declare t scroll cursor for > select * from product where company_id=1000 and product_desc like 'J%' > order by company_id,product_desc; > > QUERY > PLAN > --------------------------------------------------------------------------- >------ Index Scan using product_4 on product (cost=0.00..12306.67 rows=881 > width=181) > Index Cond: (company_id = 1000) > Filter: ((product_desc)::text ~~ 'J%'::text)
What part of "Index Scan" are you misunderstanding? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
