Re: performance issue

Hi,

>1. We have tables for each month and we are creating a view for the full
>year by
>using UNION ALL.While selecting the distinct values from the views its
>taking
>too much time.Its doing a range scan.is there any way that we can tune the
>performance while running the queries against views.

Why using distinct values when the tables are divided in months? There shouldn't be any duplicate rows.

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---