Gordowey wrote:
> Hi, simple question
>
> I have 2 hugge tables Table A and Table B. I define a view over these
> 2 tables (select,..joint,...)
>
> My question is:
> Does the DB2 runs the query every time that I access the View?
Yes, views are just "templates" of queries.

Take a look at "Materialized Query Tables" (MQT).
You define them with CREATE TABLE ... AS (SELECT...) ...

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab