I thought that an index can be used for sorting.
I'm a little confused about the following result:

create index OperationsName on Operations(cOperationName);
explain SELECT * FROM Operations ORDER BY cOperationName;
                             QUERY PLAN
Sort  (cost=185.37..189.20 rows=1532 width=498)
  Sort Key: coperationname
  ->  Seq Scan on operations  (cost=0.00..104.32 rows=1532 width=498)
(3 rows)

Is this supposed to be so?


-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.15 - Release Date: 4/16/2005

---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to