some time query took little bit long time!!!

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  July 18, 2005 at 3:08 am

  #90313

  Hello friends!! I observe that sometimes my queries took 2 0r 3 sec and sometimes it took 1.30 min or 2 mins that might be problem due to some other user access same table or view?? already i optimised my query but still it took sometimes little bit long time! if soem other user access the same table then is there any process to lock the table or waiting option ???? please help me out!!! T.I.A Shashank

  ---

  Regards,

  Papillon

• Michael Du Bois

  SSCertifiable

  Points: 5163

  More actions

  July 18, 2005 at 7:52 am

  #575181

  Hi could you send the table DDL , the query, some sample data and the expected result set.

  Thanks

  Mike