This is my first post to the list. I have a problem.
I have a table with a two index , int4, but when I do a search using the field indexed but when I applied an explain to the query it says Seq Scan , I mean , that it doesnot use the index.
I cant use the cast field::int4 because I use delphi and delphi does not support this.
I know there is a command to activate index aand always postgrres will be the index
Which are this command???
Anyone knows?
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun"
*-------------------------------------------------------*
_________________________________________________________________ ¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
