Oracle Text - Context Index Build with stored procedure is taking a long time
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:
https://mindfabblog.wordpress.com/2012/09/11/oracle-text-multiple-columns-multiple-tables/
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 questionsSorted by: Reset to defaultKnow someone who can answer? Share a link to this question via email, Twitter, or Facebook.
ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJoa3FtY2yDcoWOqKmam5yaerWx161knKeeqbK5wIyipZ2dqGKvtrXLnWSwoaSderTAzqucnWWgp7ykscOuqZ5lmah6ta3KoqWgZZFiubC6xmaroqWV