Home » SQL & PL/SQL » SQL & PL/SQL » urgent reg Index
urgent reg Index [message #19039] Tue, 26 February 2002 20:22 Go to next message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
hi
I have a table 'TEST' with two columns 'A' AND 'B'.
When i executed this query SELECT A,B FROM TEST WHERE A LIKE '212112%'; i am getting the results. But the problem is when i create an INDEX on A, I am not getting values with the same query???? But i am able to get the result with the condition
'A LIKE '%212112%'.
PLZ LET ME KNOW WHAT COULD BE THE REASON...IT IS VERY URGENT
Re: urgent reg Index [message #19043 is a reply to message #19039] Tue, 26 February 2002 22:43 Go to previous message
Milind S Deobhankar
Messages: 33
Registered: January 2002
Member
What is the datatype of column A is it varchar2 or integer then i can help to certain extent
Previous Topic: About Composite Key
Next Topic: How to find n max rows from a table without using "order by" or "group by"
Goto Forum:
  


Current Time: Thu Mar 28 12:59:09 CDT 2024