SQL optimization

Results 1 to 2 of 2

Thread: SQL optimization

  1. #1
    Join Date
    Dec 1969

    Default SQL optimization

    I have a question regarding sql. I have a inc connection file and this inc connection file is set to use intranet as database. The problem is few files use citylink database<BR><BR>So my sql I put<BR>sql_my = "SELECT cus_id FROM citylink.cfa WHERE country = &#039;my&#039;"<BR><BR>My question is should I put citylink and cfa before cus_id field in my sql above? This is because I already put citylink.cfa. I&#039;m afraid if I put, there is no difference, thus redundant. Thanks for all replies.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL optimization

    If you don&#039;t have similar names in your query (from different tables) it&#039;s optional.<BR><BR>I tend to use it for clarity though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts