Subject | Select or View |
---|---|
Author | tomkrej |
Post date | 2008-10-03T12:42:08Z |
Hi, Is there some performance difference between
select * from view_something;
and
select * from table_one, table_two where table_one.id = table_two.id;
when view is defined absolutely same as that select ???
is it automatically prepared??
Or the advantage of view is mainly in better readability of code and
security options ??
Thanks, Tom
select * from view_something;
and
select * from table_one, table_two where table_one.id = table_two.id;
when view is defined absolutely same as that select ???
is it automatically prepared??
Or the advantage of view is mainly in better readability of code and
security options ??
Thanks, Tom