>Dear, I have tags comming out of my ears. Could it be that some of these tables have an average of 60,000 records and one of them 160,000?
only if your not optimized properly. humor me... show me the SQL for the view that seems to take the longest, plus give me the index tags & expressions for each table joined.
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos