Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    30

    Unanswered: SYNONYM vs VIEW

    what's the difference between synonym and view? If i want to access in DATABASE A table AA from DATABASE B, i use create synonym AA for databasea@servera:AA, or use create a view with the same name AA on Database B, for accessing table AA in databaseA, is there any diffrence on result ? performance difference?
    Last edited by meiwen; 11-04-05 at 11:02.

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    synonyms and views are different things.

    Synonym references a table in the different database and the view is a combo of data from different tables combined into one.

    Take a look at the manual.
    Last edited by artemka; 11-07-05 at 11:49.

  3. #3
    Join Date
    Oct 2005
    Posts
    30
    YES! THANK YOU!! I forgot the basic for the view .

Posting Permissions

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