0

I write a big application by using of NHibernate ORM. Is using of full text indexing in DB level has advantages for my application performance? does it give me better performance in searches?

masoud ramezani
  • 22,228
  • 29
  • 98
  • 151

1 Answers1

2

Will turning on SQL Server Full Text searching speed up your NHibernate generated queries? No.

Creating standard indexes to cover your query workload might.

To identify your most expensive queries: How Can I Log and Find the Most Expensive Queries?

Community
  • 1
  • 1
Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541