| end-of-file on communication channel while executing the query with CONTAINS [message #133849] |
Mon, 22 August 2005 07:19 |
akshatha
Messages: 1
Registered: August 2005
Location: Bangalore
|
Junior Member |
|
|
Hi,
I have a problem while executing the query.
it gives
-2147217900 : ORA-03113: end-of-file on communication channel
OraOLEDB
I am using 'Oracle9i Enterprise Edition Release 9.2.0.1.0 '
But here very strange thing is happening. I have 2 got UNIONs here.
select .,. from <table> where contains (..) or contains (..) or contains (..) or contains (..)
union
select .,. from <table> where contains (..) or contains (..) or contains (..) or contains (..)
union
select .,. from <table> where contains (..) or contains (..) or contains (..) or contains (..)
The above query willl work fine.
I thought i would move Contains outside and put common Contains to optimise the query .
it is like
select ...... from (
select .,. from <table>
union
select .,. from <table>
union
select .,. from <table>
) where contains (..) or contains (..) or contains (..) or contains (..) or contains (..)
This will the error 'end of communication channel' error.
One more strange thing I could see is
select ...... from (
select .,. from <table>
union
select .,. from <table>
union
select .,. from <table>
) where contains (..) or contains (..)
If I limit my search for 2 conditions with CONTAINS it works fine.
Can anyone help me on this. COrrect me if my approach is wrong.
How can optimise this query?
Does MULTI COLUMN INDEX will help me on this... I am using 3 tables here for my search.
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
