obj# number, /* object number */
intcol# number, /* internal column number */
equality_preds number, /* equality predicates */
equijoin_preds number, /* equijoin predicates */
nonequijoin_preds number, /* nonequijoin predicates */
range_preds number, /* range predicates */
like_preds number, /* (not) like predicates */
null_preds number, /* (not) null predicates */
timestamp date /* timestamp of last time this row was changed */
intcol# number, /* internal column number */
equality_preds number, /* equality predicates */
equijoin_preds number, /* equijoin predicates */
nonequijoin_preds number, /* nonequijoin predicates */
range_preds number, /* range predicates */
like_preds number, /* (not) like predicates */
null_preds number, /* (not) null predicates */
timestamp date /* timestamp of last time this row was changed */
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29439655/viewspace-1356389/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29439655/viewspace-1356389/
本文详细介绍了数据库查询优化中涉及的各种参数,包括objectnumber、internalcolumnnumber等,并解释了这些参数如何帮助理解查询条件,例如equalitypredicates、equijoinpredicates等。此外,还提到了用于记录修改时间的时间戳字段。
4027

被折叠的 条评论
为什么被折叠?



