Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: Indexes and Synonyms

    Do synonyms have access to all of the indexes on the underlying table.

    We are setting up a new application with synonyms on the base tables to be used for reporting purposes. Will the synonyms be able to access the indexes the same as if the reports were pointed directly at the underlying tables?


  2. #2
    Join Date
    Jul 2003
    I don't see why they wouldn't as long as the underlysing tables were analyzed.

    You can always run a trace and see what oracle is doing.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Indexes and Synonyms

    A synonym is just that - another way of specifying the table. So whether you use the synonym or the associated table directly makes no difference.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts