cofused about SQL Optimization

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • db2db2db2@gmail.com

    #1

    cofused about SQL Optimization

    SQL: select talble1.c1
    from table1,table2
    where table1.c2=table 2.c2

    so if talbe1 has 1000 records,table2 has 100 records

    the sql statement :from table1,table2 vs. from table2,table1

    which sql will be more good for performance using db2?

Working...