Link to home
Start Free TrialLog in
Avatar of CMANI10
CMANI10Flag for India

asked on

Oracle 10G "ORACLE TEXT SEARCH"

My aim to give search option in asp dot net.
Actually Iam having two tables(eg table1 and table2 ) with each contains 20 columns.
I need to search that two tables which contain a particular word.
For that I have used the below qr=uery

select table1.c1,table1.c2,table1.c3,....,table2.c1,table2.c2,...
where table1.c1|| '-' || table1.c2|| '-' || table1.c3,....,table2.c1|| '-' || table2.c2,...
like '%test%'

The above query is working but it takes too time.
I have searched in oracle ,they saying a concept called "ORACLE TEXT SEARCH"
Can you explain how to implement this ???




Avatar of Ivo Stoykov
Ivo Stoykov
Flag of Bulgaria image

it it takes too much time there might be two main reasons (and some minors too)
either the query is badly written or
table(s) are huge.

Also depends on OS and oracle versions.

Without the query source no one could help.

As for oracle text - here you'll find lots of info - papers, technicals, articles, documentation.

HTH

Ivo Stoykov
Avatar of CMANI10

ASKER

Leave the query source and query tuning.
Is there any other way to implement this without using concordination of table columns and using " like" opperator.
if you mean where clause - yes - dynamic query.

Function that return composed where clause and the result piped to execute immediate

HTH

Ivo Stoykov
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CMANI10

ASKER

closed