Hi, I have read and worked on fulltext but everytime i stuck when there is a requirement to search database base on fulltext search and combination of other columns like varchar or date fields. Result, it take forever to search result (or at least for my case where i have 20~30 million records in my database). BTW my server setting is SQL SERVER 2005 Standard X64. Windows 2008 X64. 16GB RAM. Lets say my current structure have 2 tables CREATE TABLE Products(ProductID INT IDENTITY(1,1) PRIMARY KEY,ProductName VARCAR(MAX)) CREAET TABLE ProductDetail(FK_ID INT,ItemCode VARCHAR(4),VendorCode VARCHAR(5)) Here Products table keep unique product information whereas ProductDetail keep track of all vendorCode and ItemCode for respective products. Products.ProductID is Primary key and ProductDetail.FK_ID is Foreign key. I have FullText search on Products.ProductName and Multiple Indexes on ProductDetail. Everything work smooth as long as i do search base on ProductName but if i start combining sql criteria base on ProductName and ItemCode/VendorCode it take forever or at least take 10~15 seconds to search information (sometimes search is blank). My Products table have 20 million records and ProductDetail have around 35~40 million records. Any help will be appreciated, all article i read only talk about search base on single FullText search column/columns but not in combination of Fulltext search column and datetime/varchar columns. Regards, Waqar.