Maybe someone can shed some light on this. I'm joining on freetexttable and containstable in my query. This all runs smooth enough... however, the massive spike (from 1 second to...

incidently, the FTS part of the query is 45% of the entire thing (:w00t: )

Ye, It's definately a small database as far as SQL Server is concerned. The reason why the query might be taking so long is that it needs to join across...

I'm happy with the table structure, and the server. I'm not overly informed on index tuning to the max, but from what I know it shouldn't be a massive problem!

I might redesign the query and get back to people. I was just wondering if large enterprises use anything different!

hi, sorry. I mention in the second one that I posted it in the wrong place the first time! Can a mod please delete this thread!

Sorry!