Hello,
I am quite excited about the ‘Ubiquitous Search’ feature in 23c and feels it suitable for search needs in my application. However, when I tried to create index using DBMS_SEARCH.CREATE_INDEX on a DB view with 67K rows, index creation took ~258 secs (~5 mins) and I think this is too long since we are dealing with only few thousands of rows and I believe that Oracle text index is meant for processing millions of rows.
We have a requirement to create text index on ~ 300 million data source and looking at above stats for index creation, seems it take days to create the index on such huge data.
- Is there a way to make the creation process faster? Is there a provision to specify PARALLEL clause while creating index?
- Is there any limit on the number of data sources that can be added to the index?
- Will huge data volumes going to have negative impact on index query performance?
- I understand that Ubiquitous search internally leverages USER_DATASTORE preference, just curious to know if it uses section groups to synthesize documents?
Thanks in advance!