I am working in VFP5 and have found that I can load a grid much quicker with a view. My problem is that the table is poorly designed and has too many fields. In VFP6 there is a command SYS(3055) which is supposed to allow for more complex SQL statements. I have found nothing referring to the issue in VFP5.

What have the pros done?
Is it possible to create views from views? Silly, I know...

Does anyone have any other ideas?