I have a local VFP table of about 214,000 records. When I execute a simple SQL on it in the command window. “Select * From lrs!Names”, it return all of the records in about 1 second.

When I create a local view with no filter and no sort it takes at least 60 seconds.

When I view the SQL generated by the view, It reads exactly like the one I typed in the command window: . “Select * From lrs!Names”.

Why is the local view so much slower than the typed in SQL?

TIA