Contains Operator

• sahar.ghassami

  Newbie

  Points: 3

  More actions

  December 28, 2013 at 4:26 am

  #302739

  Hello

  I Write a query which use 'Contains' operator in it . when I execute this query in sql server 2005

  the run time is very fast but when I execute in sql server 2008 R2 it took 16 seconds . I rebuild my

  fulltext and alter all indexes in each table but did not work . Can anybody help me?

  This is my query:

  /*****

  SELECT Distinct document.DocNo,document.DocType,Title.Title,Header.WriterName+' '+Header.WriterFamily+' '+Header.Conf+' '+Header.Tanalgan

  AS Padid1,Publisher.PublisherName+' '+Publisher.PublishedPlace+' '+Publisher.PublishedDate

  As T,Rade.MainRange+'،'+Rade.Num+'،'+Rade.KaterNo+'،'+Rade.Date1 As Rade

  --,ROW_NUMBER() OVER(Order By Save1.SaveCode) AS RowNumber

  FROM Document Left Outer JOIN

  Description1 ON document.DocNo = Description1.DocNo Left Outer JOIN

  Padid ON document.DocNo = Padid.DocNO Left Outer JOIN

  Publisher ON document.DocNo = Publisher.DocNo Left Outer JOIN

  rade ON document.DocNo = rade.DocNO Left Outer JOIN

  Subjects ON document.DocNo = Subjects.DocNo Left Outer JOIN

  Title ON document.DocNo = Title.DocNO Left Outer JOIN

  Header ON document.DocNo = Header.DocNo,Save1

  Where [Document].DocNo<>'0'

  And [Document].DocNo=Save1.DocNo

  And [Document].DocType=Save1.DocType

  And document.DocType='Book'

  AND (Save1.DocStatus = 'Shelf')

  And( (CONTAINS(Title.Title , '"abc"')

  OR CONTAINS( Header.WriterName , '"abc"')

  OR CONTAINS( Header.WriterFamily , '"abc"')

  OR CONTAINS(Publisher.PublisherName , '"abc"')

  OR CONTAINS(Publisher.PublishedPlace , '"abc"')

  OR CONTAINS(Publisher.PublishedDate , '"abc"')

  OR CONTAINS(Description1.ISBN , '"abc"')

  OR CONTAINS(Title.Farvast , '"abc"')

  OR CONTAINS(Header.Tanalgan , '"abc"')

  )

  )

  AND Rade.Type='LC'

  ****/