Geek asks and answers

Oracle Feature Based Indexes

Maybe a dumb question, but is it safe to use function-based indexes. I mean, when a column changes, does the index change immediately?

+1
source share
1 answer

Assuming they are configured correctly, yes.

OVERVIEW: Oracle creates a hidden table column with a function-based index, which is updated every time the columns on which the index changes based on the function; provided the values ​​are deterministic (see oracle link for more information). You can see these hidden columns by querying the all_tab_cols system object for your table on which the index based on the function was created. They usually contain $ and look like SYS_NC00005 $.

, , , .

:

+10

More articles:


All Articles