question on nested query# Database - 数据库
c*t
1 楼
A very complex query has remote query in it.
Will it be faster to create a view for the remote query?
Will it be faster to create a view for the remote query?
m*c
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?
相关阅读
tnsnames.ora是什么东西?ACT4.0 (Symantec) foxpordatawarehouse, dataminingRe: 请教C++制作数据库的问题(continue)Perl DBI & DBDhow to do a case insensitive comparison第二课 见识一下面向对象的编程data warehouseIs there any small free database support Java ?something about SQLOracle 8i for LinuxSQL Server stupid questionsen???数据库版是新开的?有谁会用ode4.1?who used oracle 8i?sosSuffix tree and the matrix together?Re: another jobencryption