Oracle Index – Synchronize periodically

You can create an index which will be synchronized automatically everytime you commit:

Create index ... on ... INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('SYNC ( ON COMMIT)') 

or just periodically (p. x. every hour):

Create index ... on ... INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS 'SYNC (EVERY "SYSDATE+1/24")') 

See Topic on StackOverflow

Leave a comment

Your email address will not be published. Required fields are marked *