On 1/10/06, Mark <[EMAIL PROTECTED]> wrote:
> This is great,
> Now here's my explain analyze:
>
> Seq Scan on balance (cost=0.00..54.51 rows=147 width=106) (actual
> time=0.026..0.767 rows=62 loops=1)
> Filter: (amount >= 0::double precision)
>
> I do have an index on amount,
Mark <[EMAIL PROTECTED]> writes:
> I do have an index on amount, but I guess it won't be used for >= ...
The general rule is that an index is only helpful for extracting a
fairly small subset of the table ("small" can mean as little as 1%).
So a one-sided inequality is not usefully indexable unles
This is great,
Now here's my explain analyze:
Seq Scan on balance (cost=0.00..54.51 rows=147 width=106) (actual
time=0.026..0.767 rows=62 loops=1)
Filter: (amount >= 0::double precision)
I do have an index on amount, but I guess it won't be used for >= ...
is there any way
On 1/10/06, Mark <[EMAIL PROTECTED]> wrote:
> Hello,
>
> When I run 'explain analyze' on a query, how do I know what index is
> used and is it used at all. What are specific words should I look
> for?
>
> Is "Seq Scan" indicates that index has been used?
> How do I know that it was Full Table Scan?