What is optimizer statistics of a table and what is access plan of a query# Database - 数据库
h*r
1 楼
professor's requirements: Create a script that1) generates optimizer
statistics on tables,
then2) explains the access plan for a “complex”
query (must access at least 2 tables).
Have no idea of what is this at all.
thanks
statistics on tables,
then2) explains the access plan for a “complex”
query (must access at least 2 tables).
Have no idea of what is this at all.
thanks