Running Complex Queryes

From: Joviano Silva <Joviano_at_neosis.pt>
Date: 2000/04/05
Message-ID: <8cf2i9$655$1_at_duke.telepac.pt>#1/1


I have a database with 30 tables and respectively relationships between them.

To make a selection query for example with one table in a part of relationship where other part of relationship takes a condition, i have to make a join condition of 5, 6 or more tables to obtain the result. Each time i have make this kind of selection i have to run a complex join query that takes many time.
For other tables i have the same problem. Also i have to certify that information in all tables in a relationship are valid and can be obtained.

If i can assure or certify that data on each table has a relation to other tables i have to make a global query(VIEW).

I think that if we could make a View with all tables with all relationships to get all fields.
In this case it will be assured that information selected in one table has corresponding information on elsewhere table.

My question is:

it is possible to make a view like this but when we select a condition in a view, query only takes data in a view like in a table and dont run the sql code of the view with many Joins?

Like in Access we have a make table query and access data of that table instead of executing the complex query every time. There are a similar functionality in SQL Server?

Thanks in Advance,

                    Joviano
Received on Wed Apr 05 2000 - 00:00:00 CEST

Original text of this message