Make use of Database Views 

Dekho queries enable access to fields from multiple tables (from the same Data source) and provide the ability to join them to an associated Map Layer.

View1.JPG

Figure 7 - A view is a 'virtual table' that allows fields from multiple tables to be used.

Building a view at the database level makes it easier to construct queries within Dekho and may also be useful for restricting Dekho to only access a certain subset of data in one or more base tables.

In addition to the added convenience, slight performance gains can be achieved by using views.  Again, working with your Database Administrator is recommended to understand where views might be useful for Dekho queries.    

If all database performance best practises have been adhered to, performance gains can be achieved by publishing the view (or the results of an SQL query) to a standalone table in a published geodatabase on a regular basis.


Indexing with oneSearch