I have used both and they seem to run about the same speed. I only use them for querying(for now) but will be updating the sattached tables soon!! Dan Goldberg
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ramsour Mike Sent: Tuesday, August 12, 2008 8:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SATTACH performance question Good morning: Is there a difference in the speed of accessing data in foreign tables from an SATTACHed table depending on whether the "USING ALL" vs. "USING <collist>" is used? i.e. Is it better to use the "USING ALL" syntax vs. specifying exact columns vs. not specifying any columns? Thanks for any insight. Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340
