Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Delayed result with 'not like' clause in Where clause

 
Sajee Joseph
Ranch Hand
Posts: 200
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I am new to database.I have a problem with my sql query. It takes 20 secs to execute (this return 127 rows). My query has a 'not like "%xyz%" ' clause in its where clause.
When i change this 'not like' clause to 'like' clause, it returns me 137, but does this just in 1 second.
The table has around 50000 records in it.
Can someone tell me how to tune my original query to execute faster?? Has anyone experienced any problems with 'not like' clause.??
Regards,
Sajee
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
loads of things you can try.
be a bit more specific about your application, if your doing general word searching take a look at intermedia text searching.
If the 'not like' clause is always the same, then a function based index is the way to go.
50,000 isn't that big a table. how much ram do you have, sga size etc?
maybe ask in the www.dbasupport.com forums also.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic