| |
- Causa
- THE VIEW view-name MAY NOT BE USED TO OPTIMIZE THE PROCESSING OF QUERIES
The fullselect of the view includes elements that prohibit the use of the statistics on the view for optimization when the view is not referenced
directly in a query.
These elements of the fullselect might include:
- Aggregate functions
- Distinct operations
- Set operations (UNION, EXCEPT, or INTERSECT)
- Ação do sistema
- The view is successfully altered to enable query optimization.
- Resposta ao Desenvolvedor
- No action is required.
If the intent of the view is to optimize queries that do not directly reference the view, you can drop the view or have query optimization disabled.
You can also define the fullselect of the view to remove the elements that prevent optimization.
SQLSTATE: 01667
|
| |
