Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Is there a way to see the indexes on a table in SAS

Posted on 2015-02-19
1
Medium Priority
?
208 Views
Last Modified: 2016-02-13
Experts,

I am reading an Oracle table in SAS.  I know the Oracle table has indexes.  Is there a way to see them in SAS?  When I do a PROC CONTENTS it says no indexes.
0
Comment
Question by:morinia
1 Comment
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 40620224
I cannot speak to SAS but if you are connecting to an Oracle database, you have connect ability.

I would suggest something like SQL Developer:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html?ssSourceSiteId=ocomen

It's a free GUI tool from Oracle.  It will allow you to view the objects available to the user you use to connect to the database.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question