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
where table1.c1|| '-' || table1.c2|| '-' || table1.c3,....,table2.c1||
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 ???
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
where table1.c1|| '-' || table1.c2|| '-' || table1.c3,....,table2.c1||
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 ???
Oracle Database
Last Comment
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.
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
Function that return composed where clause and the result piped to execute immediate
HTH
Ivo Stoykov
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
closed
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