| not contains and performance issue [message #357747] |
Thu, 06 November 2008 08:03  |
pmapc
Messages: 46
Registered: July 2008
|
Member |
|
|
hello
I'm using ctx indexes in my application, in some queries I'm using the contains statement to improve the performance on my select queries I have a query that in this query I've used "not contains" instead of contains to simulate the not like statement this query is too slow, I want to know the reasons and how can I improve the queries that in them I want to find data that does not contains some words?
Does anybody know why this happen?
Regards,
[Updated on: Thu, 06 November 2008 08:04] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
