Create Indexes Within a View? How could I Speed up Spatial Queries Over a View?

المشرف العام

Administrator
طاقم الإدارة
I´m trying to add a view from postgis using QGIS, what´s facile. The problem is that it´s taking too long to load it and to perform any kind of operation, for example, as simple as counting rows. It´s a complex view, with 627 rows, and large geometric atribute. Is it possible to create indexes within a view?It must be told that geometric features repeat over the View, I mean, the same feature appears twice or even more along the View (is that what´s is limiting my performance)?Thanks



أكثر...
 
أعلى