| |
 |
|
Regular Expressions and Oracle Performance
Oracle Tips by Burleson Consulting
|
But regular expression are notorious for causing
full-table scans on multi-million rows tables, and special care must
be given to creating matching function-based indexes to keep
performance at an acceptable level.
From a performance perspective it’s important
to properly index the Oracle tales so that regular expression
validation does not cause problematic full-table scans. Oracle
syntax allows the use of function-based indexes (FBI’s) to minimize
the amount of database I/O associated with a invocation of a regular
expression.
Function-based indexes cannot work for all
regular expressions, however, and it can be tricky to remove
unnecessary full-table scans on some regular expressions, especially
regexp_like.
| For expert Oracle data cleansing support and
data scrubbing consulting, use an expert from BC. We
understand the powerful Oracle data unification tools, and
we can aid in improving the data quality of any Oracle
database, large or small. |
 |
 |
|
Need an Oracle Health Check?
- Do you have
bad performance after an upgrade?
- Need to
certify that your database follows best practices?
BC Oracle performance gurus can quickly
certify every aspect of your
Oracle database and provide a complete verification that your database
is fully optimized. |
|
|
