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 ???
Oracle Database
Last Comment
CMANI10
8/22/2022 - Mon
Ivo Stoykov
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
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.
Ivo Stoykov
if you mean where clause - yes - dynamic query.
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!
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.
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