| Proximity search Performance Oracle or JAVA [message #128925] |
Thu, 21 July 2005 04:57  |
karthi_dac2000
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
Dear friends,
We want to implement proximity search on a CLOB column with large text and huge number of records in an offline database.We want to know how feasible to use ORACLE CONTAINS and NEAR operator.Because We are supposed to use other conditions along with this proxumity also.
How will be the intermedia search performance compared to normal JAVA class searches in the table with its basic search APIs?
Are they any JAVA oracle intermedia API available and how feasible they are?
If to use oracle CONTAINS then,can we have additional conditions in where clause along with CONTAINS?
Please clarify at your earliest convienence.
Thanks in advance
Karthi
|
|
|
|
| Re: Proximity search Performance Oracle or JAVA [message #129036 is a reply to message #128925] |
Thu, 21 July 2005 11:53  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
Is it feasible? I'm not sure what kind of answer you are expecting here. The NEAR operator is a built-in feature of Oracle Text, so, yes, it is feasible. Whether or not the performance will be acceptable to you is another issue, but Oracle Text is highly optimized.
Yes, you can combine other search criteria with CONTAINS.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
