Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

执行计划出现COLLECTION ITERATOR PICKLER FETCH

WBOY
Release： 2016-06-07 15:53:53
Original
1968 people have browsed it

执行计划出现COLLECTION ITERATOR PICKLER FETCH

今天在使用explain plan for查看sql执行计划时，出现了如下奇怪的执行计划

经过排查，，发现是在使用explain plan for之前执行过set autotrace on，关闭autotrace后执行计划就显示正常，一点小知识，记录以供参考。

本文永久更新链接地址：

Related labels：
Oracle执行计划 执行计划出现COLLECTION IT
source：php.cn
Previous article：使用XtraBackup备份恢复MariaDB数据库 Next article：误删重做日志文件组导致启动数据库报错ORA-03113
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Optimize the query to add content to the current time in WHERE I have a query that is doing the following: ANDTIME(NOW()+INTERVALli.tzOffsetHOUR-INTERVAL...
From 2024-04-04 22:45:06
0
1
296
My multiply (*) command doesn't calculate My asterisk is not working, when I do the calc() function and do the multiplication notati...
From 2024-04-04 21:18:17
0
1
315
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template