If we assume that the dba is never interested in running his or her own queries, does the dba still need to understand query optimization? why?
Answers
Answered by
7
esigning the logical and physical schemas, as well as widely-used portions of the externalschema.Security and authorization.Data availability and recovery from failures.Database tuning: The DBA is responsible for evolving the database, in particular theconceptual and physical schemas, to ensure adequate performance as user requirements
Answered by
0
Answer:yes,dBA still needs to understand query optimizationoptimizationthe DBA is concerned about system performance amping their other duties bad queries can several bad impact system performance so understand query optimization is important,so they can recommended query changes that are less impactcul to system
Explanation:
Similar questions