c**t
发帖数: 2744 | 1 A very complex query has remote query in it.
Will it be faster to create a view for the remote query? | m****c
发帖数: 8 | 2
It depends on what kind of view you are going to create. In oracle, they have
materialized view, that will speed up the query. But you still need to check
the query executing path, and make sure using the correct index, joins etc.
【在 c**t 的大作中提到】
: A very complex query has remote query in it.
: Will it be faster to create a view for the remote query?
|
|
