David

The matter of index maintenance is a real one. It does take longer to update when you add another index to a PF. So it is a classic tradeoff. And if possible, they are sharing indexes to the nines. That minimizes the access path update issue.

Centerfield Technology, where Elvis B. works and I used to work, has tools & services to help analyze this index usage.

Vern

At 01:43 AM 3/13/2008, you wrote:

I love hearing about the world outside our company, as I have only ever worked here as a developer.
When you say, " Now we just specify the key needed for the application", you mean the key on the LF?

Would this kind of system be possible for us? We have a lot of users with a lot of interactive applications using the same big PFs. Wouldn't that cost a lot in ressources? I mean, each application would be continually updating all the LF dependant on the physical file?

Thanks a lot for this great practical example, even if it's not a solution for us. I hope other members on the list will follow.


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].