| Index question [message #280241] |
Mon, 12 November 2007 23:18  |
ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA
|
Member |
|
|
Hello experts,
I have question regarding index.
I have a query which used to work fine. But recently the data changed in one of the tables due to which one of the index is not used. Is there any way we can force that indexed to be used?
For example:
one of the join condition was
a.id=b.id
Previously precision of both the columns is 11. Now precision of b.id became 15 because of which i had to modify the query as
a.id=substr(b.id,1,11) which is causing index not to be used.
I tried using INDEX(<table_name>, <index_name>) hint, but dint help.
Is there any workaroud?
thnaks
|
|
|
|
|
|
|
|
|
|
| Re: Index question [message #280450 is a reply to message #280245] |
Tue, 13 November 2007 12:20  |
ravikanth_b
Messages: 42
Registered: November 2007
Location: Bay Area, CA
|
Member |
|
|
We have data coming from different sources for table A and table B. In one of the sources, the id column is padded as id+encoded value. I am taking the id out by using substring. Here no integrity constraint is violated. The idea is to get a resultant table using table A and table B.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
