The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Buzz Forum
How to Quickly Enumerate Indexes in Oracle 11gR2

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
justin cater

Posts: 19616
Nickname: justin78
Registered: Mar, 2011

Justin Cater is executive editor at Java Code Geeks
How to Quickly Enumerate Indexes in Oracle 11gR2 Posted: Oct 10, 2015 11:01 AM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by justin cater.
Original Post: How to Quickly Enumerate Indexes in Oracle 11gR2
Feed Title: Java Code Geeks
Feed URL: http://feeds.feedburner.com/JavaCodeGeeks
Feed Description: Java 2 Java Developers Resource Center 		Latest Java Buzz Posts
Latest Java Buzz Posts by justin cater
Latest Posts From Java Code Geeks

Advertisement
Do you want to know real quick what kind of indexes there are on any given table in your Oracle schema? Nothing simpler than that. Just run the following query: SELECT i.index_name, listagg(c.column_name, ', ') WITHIN GROUP (ORDER BY c.column_position) AS columns FROM all_indexes i JOIN all_ind_columns c ON i.index_name = c.index_name WHERE i.table_name = ...

Read: How to Quickly Enumerate Indexes in Oracle 11gR2

Topic: Global Data Consistency, Transactions, Microservices and Spring Boot / Tomcat / Jetty Previous Topic   Next Topic Topic: You Probably don’t Use SQL INTERSECT or EXCEPT Often Enough
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use