Oracle如何实现利用实体化视图提高查询性能
摘要:实体化视图不仅可以作为远程复制查询的功用,而且能够提高复杂的统计查询的性能.1.创建查询语句对应的实体化视图. SQL> conn sh/sh;SQL> create materialized view mv_sales 2 refresh complete 3 start with sysdate next sysdate+1 4 as select PROD_ID,Count(P...
阅读全文
posted @
2007-02-08 16:30
Shark Xu
阅读(1128)
推荐(0) 编辑
如何恢复一个只有完好数据文件的Oracle数据库?
摘要:1.重新创建初始化文件,重要的参数包括 control_files,db_name,instance_name,background_dump_dest,core_dump_dest,user_dump_dest,\ db_block_size=8192,db_cache_size,db_domain,large_pool_size,pga_aggregate_target,shared_po...
阅读全文
posted @
2007-02-07 16:34
Shark Xu
阅读(1949)
推荐(0) 编辑
Overview Shark DB Expert
摘要:1. Connect multi-database in the same time. Exampe:Oracle,Sybase,MS SQL,DB2, MS Access,MySQL,Paradox,DBF,MS Execl,Text. Please click here download. 2. List Table/View/Procedure/User-Define-Function/System Table(only in MS SQL,Sybase)/ if connection is Oracle,the following db object will be listed:Sy
阅读全文
posted @
2007-02-06 16:02
Shark Xu
阅读(3248)
推荐(0) 编辑