CREATE SQL VIEW (lcView) AS ; SELECT ; pri.plot_id, pri.meridian, pri.section, pri.strip, pri.plot_num, ; ; pri.plottype_id, pt.name as pt_name, ; ; pri.ws_id, wss.name as ws_name, ; ; pri.dist_id, dst.name as dist_name, ; ; pri.latitude, pri.longitude, pri.travel, pri.cruisers, pri.date, ; pri.elevation, pri.slope, pri.baf, pri.calc_site, pri.mgmt_site, ; ; pri.ldeleted ; FROM FORCE PlotFilter flt ; JOIN crzplots pri ON pri.plot_id = flt.linkfield ; JOIN watersheds wss ON wss.ws_id = pri.ws_id ; JOIN districts dst ON dst.dist_id = pri.dist_id ; JOIN plot_type pt ON pt.plottype_id = pri.plottype_id ; ORDER BY meridian, section, strip, plot_numBefore, try the view without the ORDER BY and see the time.
SELECT ... FROM crzplots pri where .F. INTO CURSOR myView READWRITE SELECT crzplots SET ORDER TO meridian_section_strip_plot_num SCAN FOR InsertThisCondition INSERT INTO myView .... ENDSCANFabio