Hi, We created a database with some boxes in it. We make spatail queries on the boxes. like: SELECT openMapIndex FROM tableName WHERE BBOX::box && '((-73,45),(-74,46))'; The query is working fine. We indexed the field BBOX. It takes about 17 seconds when doing a sequential search and 0.5 second when doing an indexed scan. Here is our problem. Postgresql does not by default use the index, which is strange given the benefits of it. When we do the EXPLAIN command, it says that it will do a sequential search. The only way we found for it to use the index is to set the "ENABLE_SEQSCAN" variable to "OFF". But that just work for one session. We are connecting remotely to the database throught JDBC and we do not find a way to force the indexed scan. Anybody has an idea of what we are doing wrong? Thanks -- _______________________________________ Michel Nadeau / [EMAIL PROTECTED] Programmeur-Analyste Le Groupe KOREM inc. Conna�tre et g�rer son territoire / La g�omatique au service des technologies de l'information. 680, boulevard Charest Est, 1er �tage Qu�bec (Qu�bec) G1K 3J4 t�l. : (418) 647-1555 fax : (418) 647-1666 http : //www.korem.com _________________________________________
