Description: ENABLE applies only to a function-based index that has been disabled because a user-defined function used by the index was dropped or replaced. This clause enables such an index if these conditions are true:
- The function is currently valid
- The signature of the current function matches the signature of the function when the index was created
- The function is currently marked as DETERMINISTIC
You cannot specify any other clauses of ALTER INDEX in the same statement with ENABLE.
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.