This query taking long time for execution inthis case what should i do

• naga.rohitkumar

  SSCertifiable

  Points: 5561

  More actions

  November 22, 2012 at 3:13 am

  #270431

  HI all

  SELECT Rtrim(CUST_ACID),rtrim(pmt_id),rtrim(AC_NAME),rtrim(txn_amt),rtrim(pmt_rmks) from payawdb.dbo.pmts,acmt where payawdb.dbo.pmts.cust_acid=acmt.acid and bill_ref_info in

  ('57263259')

  1.this query is taking long time for execution and what should i do ?[production server ]

  2. it actually takes form one table to another from two databases

  3. can i check the indexes of these tables and if i rebuild will it increase performance ?

  4 or whether it will effect on production ??

  Thanks
  Naga.Rohitkumar

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  November 22, 2012 at 10:30 am

  #1561680

  Please read this article. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]

  At minimum, please post DDL for all involved tables including the indexes and an actual execution plan for the query.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato