Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Unanswered: Database Performance Query

    Hi All,

    Thank dbforums, It is my first post here and hopefully can learn more from you guy.

    I currently trap SQL performance problem, I wanna ask is that any factor cause below similar SQL query time is so different.

    SQL 1 - query time 0.01 second
    SELECT *
    FROM Employee T1, Salary T2, PersonalDetail T3
    WHERE T1.Emp_id = T2.Emp_id
    AND T1.Emp_id = T3 = T3.Emp_id
    AND ROWNUM < 1000


    SQL 1 - query time > 7 minutes.
    SELECT *
    FROM Employee T1, Salary T2, PersonalDetail T3
    WHERE T1.Emp_id = T2.Emp_id
    AND T1.Emp_id = T3 = T3.Emp_id
    AND ROWNUM < 10000

  2. #2
    Join Date
    Sep 2011
    Posts
    75
    Hello,

    Do you need all the columns of all the tables specified or there is a certain list of them if yes then fetch only the required columns instead of whole table and use inner join instead of using eqi join

Posting Permissions

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