[PERFORM] My indexes aren't being used (according to EXPLAIN)

lready answers this question. Thanks in advance! -Erik Norvelle

Re: [PERFORM] My indexes aren't being used (according to EXPLAIN)

The ANALYSE did the trick... Thanks! Will also read through the archives... -Erik On lunes, dici 1, 2003, at 15:04 Europe/Madrid, Andrew Sullivan wrote: On Mon, Dec 01, 2003 at 02:40:30PM +0100, Erik Norvelle wrote: it= explain select * from indethom where clavis 25; What's the percentage

[PERFORM] Update performance ... is 200,000 updates per hour what I should expect?

refere2b, refere3a, refere3b, refere4a, refere4b), verbum_ndx btree (verbum) Thanks for your assistance! -Erik Norvelle

[PERFORM] Slow performance with Group By

for any help you all can offer!! Erik Norvelle ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match