Specifying a DDS described logical file in a SQL statement is not a good
idea (and never was).
There is a nice whitepaper about indexing and statitisc strategies written
by Kent Milligan and Mike Cain, which should be learned "by heart".
Here is the link: