---
title: "查询表分析时间"
author: "hotjava"
date: "2008-04-22T15:15:02Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-04-22T15:15:02Z"
id: 185476
url: "https://hotjava.iteye.com/blog/185476"
---

select ut.table_name,ut.last_analyzed,ut.partitioned,ut.num_rows from user_tables ut 
order by 2,1

如果发现有索引实效的情况，可以查一下表分析的时间，来判定导入数据以后是否执行了表分析。