Selecting from an external table reads the data from the data file(s) and provides it in the form of rows and columns as if it was read from the normal base table.
从外部表选择可从一个或多个数据文件读取数据,并以行和列的形式提供该数据,就好像从常规基表读取数据一样。
It turns out to be a sort of high-quality, unusually rigorous coffee-table book, designed to be dipped into rather than read from beginning to end.
它其实是一本高质量、异常严谨的咖啡桌书籍,写作的初衷是让读者大致浏览里面的内容,而不是从头读到尾。
With this type of lock, concurrent applications can read from or write to the locked table.
有了这一类型的锁,并发应用程序就可以读或写已锁定的表。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
Listing 2 displays sample code to get columns from a table and read their properties.
清单2显示了从一个表中获取列并读取它们的属性的示例代码。
Since relational data and indexes are stored in separate storage objects within a table space, they have separate read and write counters.
由于关系数据和索引存储在表空间内不同的存储对象中,因此它们具有不同的读和写计数器。
When a table holds a Z lock, no concurrent application can read or update data in that table.
当表持有z锁时,任何并发应用程序都不能读取和更新该表中的数据。
Queries that only access the relational columns of the table now need to read a much larger number of pages than without inlining.
对于只访问表的关系列的查询,现在所需读取的页面数要远远超过未实现内联时需要读取的页面数。
As you can see, this table is much easier to understood, read, and update by business users.
如您所见,这个表更容易被业务用户理解、阅读和更新。
Other applications that want to access data in the same table concurrently do not need to disconnect from the database, and are free to pursue read or write operations in that table.
其他想要并发访问相同表中的数据的应用程序不需要与数据库断开连接,并且可以继续进行该表中的读或写操作。
You should read table PA0006 to get setup data needed to obtain current address data and also to update address data.
读取表pa0006以获得设置信息,以便能够获取当前的地址数据和更新地址数据。
It allows applications to perform constant data load operations to a table in the background while the interactive read and write operations can occur concurrently.
它允许应用程序在后台对表执行恒定数据加载操作,同时可以执行交互式读取和写入操作。
When a table holds an IX lock, the lock owner and concurrent applications can read and update data in that table.
当表持有IX锁时,锁拥有者和并发应用程序可以读和更新该表中的数据。
The simplest way is to read the table's data sequentially, performing a table scan as we usually call it.
最简单的方法是连续读取表中的数据,就是按照我们通常调用它的方法来执行表扫描。
Ideally, the indexes provide enough information to read in only the needed rows, but sometimes queries (through poor design or the nature of the data) require large chunks of the table to be read.
理想情况下,索引提供了足够多的信息,可以只读入所需要的行,但是有时候查询(设计不佳或数据本性使然)需要读取表中大量数据。
At last the candle was lighted; he leaned his elbows on the table, unfolded the paper, and read.
最后,他的蜡烛算是点上了,他两肘支在桌上,展开那张纸来看。
Moreover, if an ALLOW read ACCESS load operation fails or is aborted, pre-existing table data can still be read.
此外,如果ALLOWREADACCESS加载操作失败或者被中断,预先存在的表数据仍然可以被读取。
This means that a sequential scan of the table will be faster than an indexed read, and we cannot play with the filter criteria.
这意味着对表的顺序扫描比索引读取更快,我们无法遵循指示器标准。
To make the table easier to read, we've only included the dates of the initial changes that we made.
为了让这个表简明易读,我们仅包含最初更改的日期。
If so, the existing ID is read from the dimension table and used as the foreign key for the new entries in the fact table.
如果是,则从维表中读取已有的ID,并用它作为事实表中新条目的外键。
PREFETCHSIZE specifies the number of pages to be read from the table space when data prefetching is being performed.
PREFETCHSIZE指定在执行数据预取时将从表空间读取的页数。
There are two options for user access to a table while a RUNSTATS is running against that table: allow read access and allow write access.
当对一个表运行RUNSTATS时,有两种用户访问选项:允许读访问和允许写访问。
Since the table is "empty," it is obviously easiest to read the entire table rather than trying to use an index.
由于表是“空”的,那么很显然读取空表比采用索引更简单。
A file system is a formatting of the disk into a table that the operating system can read, interpret, and write to.
文件系统就算把硬盘格式化成系统可以读写操作的一种“表”结构。
Those interested in this can read the white paper Partitioned Table and Index Strategies Using SQL Server 2008.
对此感兴趣的读者可以阅读白皮书《使用SQL Server 2008的分区表和索引策略》。
Result: the data from the back-end testtab table is shown because the passthrough Read level is set to FORCE.
结果:后端testtab表中的数据显示,因为将passthroughRead级别设置为FORCE。
For example, if you set this option to 2, you will have two db2bm processes that can each read two separate table Spaces in parallel.
例如,如果将此选项设置为2,那么将会有两个db 2bm进程,每个进程并行地读取两个不同的表空间。
Unfortunately, none of the partitions are in formats that are familiar to OS X, but my Mac Mini could read the partition table. Here's the partition map
不幸的是,这些分区使用的都不是OSX所熟悉的格式,但是我的MacMini可以读取这个分区表。
Quiesced exclusive 0x4 a table space is in this state when the application that invokes the table space quiesce function has exclusive (read or write) access to the table space.
Quiesced Exclusive0x4当调用表空间静默(quiesce)功能的应用程序独占(读或写)访问表空间时,该表空间就处于这种状态。
The second key piece of information is that we are trying to read the bills table using a customer_number.
第二条关键信息是我们正尝试利用customer_number来读取账单表。
应用推荐