Problem about the Execution Time

[Former Member]

Hi friends,

If we fetch data from view and fetch it directly from database table

Does it make any difference in Execution Time.

If yes, then which one is preferable way for fetching data.

If anybody give me some guidance for fecthing data which will take less execution time, it is really very helpful to me.

Thanks in advance,

Dharmishta

[Former Member]

Such a generall question does not really make sense

A view can be a project, i.e. one table with less fields, the effect will be the same

as using a field list. Just simpler to code.

A view can be a join of several tables, usually from performance the same as the join, just simpler to code.

In rare case a view can be materialized, it exists on the database and not just as defintion. Recommended only in ver y exceptional cases, can make problems!

Siegfried