Please forgive a non SPSS-specific question, but I've always been curious why the query design wizard uses aliases for table names in constructing SQL queries of ODBC databases. But then yesterday I converted tables names to aliases in an update query I use in M$ Access. I did that purely for ease of maintenance, but all of a sudden the query seems to be running much faster than before. Is there some reason why using aliases would accelerate an ODBC query?
Thanks for any insight,
--Bud
Meredith (Bud) Bliss
Crime Analyst - Beaverton Police Dept.
4755 SW Griffith Drive
Beaverton, OR 97005
503-526-2294 - Fax: 503-526-2541
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
