Re: Oracle in system i termonology

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Index = keyed logical
View = unkeyed logical with dropped fields, substringed fields, ect..
plus lots more you can do in an DDS logical.

One thing to understand, with RPG and record level access, you
explicitly open and use a keyed logical.

Whereas with SQL, on either the i or Oracle, you use the physical
table (PF) or view and behind the scenes the query engine may or may
not use the index.

HTH,
Charles

On Thu, Mar 12, 2009 at 4:01 PM, Adam West <adamster@xxxxxxxxx> wrote:
> HI I was wondering if there is someone in the group who knows both system i and Oracle and could then explain the basiscs to me in system i terms of the Oracle setup. I am not sure for example what is meant by indices or is this like a Logical file.
>
> TIA,Adam
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.