Re: To Key or Not To Key a Physical

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Yeah, the SQL optimizer might create an index from an index, but that is 
not the same thing at all.

Vern

Charles Wilt wrote:
> Huh?
>
> If you create a logical with the same access path as the physical, the
> logical will share the PF access path.
>
> Now-a-days, the recomendation is to always define a primary (aka
> unique, non-NULL) key for the physical.
>
> Charles
>
> On Thu, Mar 26, 2009 at 2:13 PM, Kurt Anderson
> <kurt.anderson@xxxxxxxxxxxxxx> wrote:
>   
> > If I'm going to have multiple logical files over a physical file, is it better to not key the physical file or is there no implication if I do key the physical file (and reduce the number of logicals needed by 1)?
> >
> > I'm not that familiar with how indexing works, and the concern is that a logical over a keyed physical will be indexing from an index.
> >
> > Thoughts?
> >
> > Thanks,
> >
> > Kurt Anderson
> > Sr. Programmer/Analyst
> > CustomCall Data Systems
> > --
> > 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.
> >
> >
> >