IQSChris
Technical User
- Nov 1, 2007
- 11
Hello,
I'm not sure exactly where to post this in tek-tips...
Coming from an AS400 reporting environment against a JD Edwards ERP system - The ERP system had physical files(PF) and logical files(LF). A single PF could have multiple LF's, each with different Key fields. K01 identifies the first field that is sorted, K02 is the second subsort, K03 the third...and so on. I could choose the appropriate LF based on a reports selection (where clause). Usually it would improve a reports performance by matching up the appropriate LF that sorted by my selection criteria.
Now I'm in a SQL Server/Oracle environment. The tables have indexes, but appear different than Key fields.
Does the equivalent of LF's exist in the SQL Server/Oracle environment?
Could anyone help me to understand the difference?
Thank You,
Chris
I'm not sure exactly where to post this in tek-tips...
Coming from an AS400 reporting environment against a JD Edwards ERP system - The ERP system had physical files(PF) and logical files(LF). A single PF could have multiple LF's, each with different Key fields. K01 identifies the first field that is sorted, K02 is the second subsort, K03 the third...and so on. I could choose the appropriate LF based on a reports selection (where clause). Usually it would improve a reports performance by matching up the appropriate LF that sorted by my selection criteria.
Now I'm in a SQL Server/Oracle environment. The tables have indexes, but appear different than Key fields.
Does the equivalent of LF's exist in the SQL Server/Oracle environment?
Could anyone help me to understand the difference?
Thank You,
Chris