AS / 400 DB2逻辑文件与表索引 [英] AS/400 DB2 Logical File vs Table Index

问题描述

我来自MSSQL的背景，当我询问我公司的人是否在某些列上创建了索引时，他们会说是的，但指出这些东西称为逻辑文件。

在iSeries导航器中，这些逻辑文件显示在视图类别下。当我点击索引类别没有什么，导致我相信实际上没有在任何列上创建索引，至少在我理解的时候。逻辑文件似乎是按某些列排序的视图。

所以我的问题是，是逻辑文件和索引（MSSQL的索引）同样的事情吗？ / p>

解决方案

根据这个描述，AS / 400 DB2逻辑文件在大多数其他关系数据库中称为视图。我不得不说，我不认为逻辑文件与索引相同。

I'm coming from a MSSQL background, and when I ask people at my company if they've created Indexes on certain columns they'll say yes but point me to these things call Logical Files.

In the iSeries Navigator these Logical Files show up under the 'Views' category. When I click the 'Indexes' category nothing is there, leading me to believe that there are actually no Indexes created on any columns, at least as I understand them. A Logical File appears to be a View sorted by certain columns.

So my question is, are Logical Files and Indexes (indexes in the MSSQL sense) the same thing?

解决方案

According to this description, an AS/400 DB2 Logical File is called a view in most other relational databases. I'd have to say that I don't think a logical file is the same as an index.

这篇关于AS / 400 DB2逻辑文件与表索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！