#11017: Oracle LIKEC query doesn't use index
------------------------------------------+---------------------------------
 Reporter:  jtiai                         |       Owner:  nobody    
   Status:  new                           |   Milestone:            
Component:  Database layer (models, ORM)  |     Version:  SVN       
 Keywords:  oracle                        |       Stage:  Unreviewed
Has_patch:  0                             |  
------------------------------------------+---------------------------------
 It seems (not confirmed from Oracle officially) LIKEC query doesn't use
 index at all, you get always full table scan that is costly when number of
 rows starts to grow.

 Like queries uses index as expected with same parameters.

 Change was done when fixing #5985

-- 
Ticket URL: <http://code.djangoproject.com/ticket/11017>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to