Viewing index data in DDL

1215 pts.
Tags:
Data Definition Language
DDL
DDL Index
I have created index. It shows Type as *FILE and Attribute as LF. but I'm unable to view the data. How do I view index's data?

Answer Wiki

Thanks. We'll let you know when a new response is added.

well you cannot view the contents of a logical file of type *LF,but you can view the physical file for which that logical file belong.
i suggest you , you write GO QUERY, and then write the name of the logical file and specify the library, and press F5 with no selection,

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    More information is needed here. What database are you using ? What data do you want to see ? Indexes are usually used to speed the readings of data in a table, so what you really see is the table data, being accessed with the help of an index.
    68,015 pointsBadges:
    report
  • rajeshece
    Using SQL Statements , I have created a index
    1,215 pointsBadges:
    report
  • NANAK
    please i also have a familiar issue. i want to create an index for a view so the the the individual record can be assessed faster. but i know that the view takes it data from from the author table. please how do i do this
    25 pointsBadges:
    report
  • NANAK
    please i am using an oracle database
    25 pointsBadges:
    report
  • carlosdl
    NANAK, you can't create indexes on views. Your best bet would be to create appropriate indexes on the underlying tables, to make sure your view's query runs fast.
    68,015 pointsBadges:
    report
  • TomLiotta
    i want to create an index for a view so the the the individual record can be assessed faster. You can create an index with no concern about any view. It doesn't have to be "for a view". SQL will use the index the same way. It wouldn't be any faster if it was "for a view". Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following