Problem: 为什么已经创建了金字塔了,ArcSDE的影像显示还是非常慢
文章编号 : 22572
软件: ArcGIS - ArcEditor 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcInfo 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcView 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcSDE 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1
操作系统: N/A
软件: ArcGIS - ArcEditor 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcInfo 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcView 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcSDE 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1
操作系统: N/A
1 个回复
EsriSupport
赞同来自:
原因: 影像表没有进行分析优化
解决方法: 有许多方法来解决相关问题
1:ArcCatalog选择对象右键,选择“分析(Analyze)”
2:SDE命令执行sdetable -o update_dbms_stats ...
C:\>sdetable -o update_dbms_stats -t mosaic_test -i 5151 -u test -p XXXXXX -m <ESTIMATE |
COMPUTE>
ArcSDE 9.1 Oracle10g Build 372 Mon May 22 12:10:17 PDT 2006
Attribute Administration Utility
-----------------------------------------------------
DBMS statistics for table mosaic_test updated.
DBMS statistics for raster tables updated.
3:在ArcGIS9.x使用命令行,相关信息查看ArcGIS Desktop 帮助,选择查找页,键入“Analyze”关键字获得相关的结果
Analyze 'Database Connections\RASTER_ora@BUCCANEERS@5151(esri_sde).sde
\RASTER.MOSAIC_TEST' BUSINESS
Analyze 'Database Connections\RASTER_ora@BUCCANEERS@5151(esri_sde).sde
\RASTER.MOSAIC_TEST' RASTER
4:使用Python
#Purpose: Analyze a database table after data loading
#
#Create the Geoprocessor object
from win32com.client import Dispatch
gp = Dispatch("esriGeoprocessing.GPDispatch.1")
try:
#Set the workspace (to avoid having to type in the full path to the data every time)
gp.Workspace = "Database Connections\TEST_ora@BUCCANEERS@5151(ora_sde).sde"
# Process: Update business rules statistics of a table
gp.Analyze("test.mosaic_test","BUSINESS")
gp.Analyze("test.mosaic_test","RASTER")
print gp.GetMessages()
except:
#If an error occurred while running a tool print the messages
print gp.GetMessages()
5:在数据库之间对影像数据进行分析
Oracle :
======
DBMS_STATS package
SQL Server :
==========
CREATE STATISTICS command
创建时间:2002-05-28
最近更新: 2010-06-17
【原文链接】
http://support.esrichina.com.c ... .html
要回复问题请先登录或注册