Accurately representing the statistics characteristics for a remote view is tricky.
准确地表示一个远程视图的统计特征很有技巧。
A nickname can be defined over a remote view just as it can be defined over a remote table.
可以定义远程视图的昵称,就像定义远程表的昵称一样。
For example, at Oracle, you can use the following remote view definition that will exclude the XML declaration.
例如,在Oracle,可以使用如下的远程视图定义来排除XML声明。
The table CUSTOMER_INFO is stored in a DB2 9 database, and its XML data is serialized into a BLOB column using the following remote view.
表CUSTOMER_INFO存储于DB 29数据库中,其XML数据通过如下所示的远程视图序列化进blob列。
If the remote view contains a complex query, using table-level statistics such as the cardinality for the nickname over the view can be misleading.
如果远程视图包含一个复杂的查询,那么使用表级统计信息(例如视图昵称的基数)可能使人产生误解。
For instance, you can also create a nickname over a remote view that extracts part of an XML document or the value of an element. The Oracle view below will return the content of an XML element.
比如,您也可以在远程视图之上创建昵称,这个远程视图提取部分XML文档或元素的值。
For instance, you can also create a nickname over a remote view that extracts part of an XML document or the value of an element. The Oracle view below will return the content of an XML element.
比如,您也可以在远程视图之上创建昵称,这个远程视图提取部分XML文档或元素的值。
应用推荐