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,

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

Processing your response...

Discuss This Question: 6 &nbspReplies

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

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

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.

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

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

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

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