... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.oracle

Overblown overpriced overengineered SHIT

2,288 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 624 of 2,288

LKBrwn_DBA to All

Re: sql using full table scan instead of

31 Oct 03 12:45:23

   From: member30625@dbforums.com   
      
   Try giving it a HINT:   
      
      
      
      
   select /*+ INDEX(CHILD pkey) */ CHILD.*   
   from CHILD, PARENT   
   where PARENT.value=100   
   and CHILD.pkey=PARENT.pkey   
   and PARENT.vdate between date1 and date2;   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]