View Single Post

   
  #6 (permalink)  
Old 04-09-2008, 10:57 AM
Richard Broersma Jr
 
Posts: n/a
Default Re: Tuning to speed select

> Views certainly help in managing complexity. They do nothing to improve
> query-speed.
>
> Querying a view gets rewritten to queries to the underlying tables on the
> fly.
> (as long as there are no materialized views, which are still on a the TODO
> list)


Would partial indexs on the most queried regions of the table help in query speed?

Regards,

Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote