searching using indexes 8.3
От | LARC/J.L.Shipman/jshipman |
---|---|
Тема | searching using indexes 8.3 |
Дата | |
Msg-id | 3D53CC73-3BEA-483E-A396-3EFE7293A29D@nasa.gov обсуждение исходный текст |
Ответы |
Re: searching using indexes 8.3
Re: searching using indexes 8.3 Re: searching using indexes 8.3 |
Список | pgsql-general |
Hi,
When I do a search such as:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
Seq Scan on itemsbyauthor (cost=0.00..971.34 rows=53634 width=34) (actual time=0.029..25.831 rows=53634 loops=1)
Total runtime: 34.851 ms
(2 rows)
I have an index for the table, but it is not being utilized. Why is this? How do I get the index to be used?
757-864-7114
LARC/J.L.Shipman/jshipman
В списке pgsql-general по дате отправления: