|
Home > Archive > SQL Anywhere database > July 2005 > Views in ASA 9
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi all,
I'm using ASA 9.0.2 and it happens that I execute some queries that contain
8 or 9 tables in the from clause
My question is, if I create a view grouping all these tables, will that be
increasing the query performance ? or will it stay the same
I'm trying it, but I will appreciate an experienced opinion
Regards
Rabih
| |
| Chris Keating \(iAnywhere Solutions\) 2005-07-26, 9:23 am |
| A view is just the underlying query so you will not see performance gains.
Have you used the index consultant to see it makes any recommendations?
"Rabih" <rabih_maalouf@ipsos-stat.com> wrote in message
news:42e642ae@forums
-1-dub...
> Hi all,
> I'm using ASA 9.0.2 and it happens that I execute some queries that
> contain
> 8 or 9 tables in the from clause
> My question is, if I create a view grouping all these tables, will that
> be
> increasing the query performance ? or will it stay the same
> I'm trying it, but I will appreciate an experienced opinion
>
> Regards
> Rabih
>
>
>
|
|
|
|
|