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

问题描述

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

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.

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

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.

所以我的问题是，逻辑文件和索引(MSSQL 意义上的索引)是一回事吗?

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

推荐答案

据此说明，AS/400 DB2 逻辑文件在大多数其他关系数据库中称为视图.我不得不说我不认为逻辑文件与索引相同.

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屋！