---
title: "查询索引状态"
author: "hotjava"
date: "2008-06-04T11:09:16Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-06-04T11:09:16Z"
id: 200028
url: "https://hotjava.iteye.com/blog/200028"
---

select t.index\_name,  
       t.table\_owner,  
       t.index\_type,  
       t.tablespace\_name,  
       t.partitioned,  
       t.status,  
       t.last\_analyzed  
  from dba\_indexes t  
 where t.table\_owner = 'RMS'

 

查询索引,根据索引的状态和时间来判定索引是否失效.