i am looking for a way to do a free text search on an oracle database, i am using 11.2.0.4 currently.

After some research it appeared that Oracle Text was the way to go. i built a stored procedure that basically concatenates the column data that i want to index across multiple tables and index based off that: See some of the important commands below.

But essentially followed this document:

BEGIN CTX_DDL.create_preference('search_datastore', 'USER_DATASTORE'); CTX_DDL.set_attribute('search_datastore', 'PROCEDURE', 'concat_cols');
END; CREATE INDEX "DBNAME"."SEARCH_IDX" ON "ERM2"."CUSTOMER_DATA" ("SEARCH_INDEX")
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('datastore search_datastore);

The issue I have is that it is taking ages to build the index is there a better way of achieving what I want? or speeding my index build up?

2 Related questions 0 slow sql query execution 2 (oracle) insert in stored procedure very slow compared to insert run manually 0 Index Created but doesn't speed-up on retrieval process Related questions 0 slow sql query execution 2 (oracle) insert in stored procedure very slow compared to insert run manually 0 Index Created but doesn't speed-up on retrieval process 0 Oracle SQL query taking too long like 60 minutes to execute 0 Improve the stored procedure performance 0 PLSQL Procedure taking lot of time to execute 2 Oracle Stored Procedure performance 0 Oracle procedure with CDT as input parameters is very slow 0 Slow Oracle execution 0 Oracle - performing slow Load 7 more related questions Show fewer related questions Sorted by: Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.