Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34

    Unanswered: Sybase Questions

    Hi Folks,
    Please help me to get answer of below question.
    1) How can I list/see the permissions on the specific table.
    2) Syabse does not support full outer join then how we will achieve this FULL OUTER JOIN concept in Sybase.
    3) what is the difference between NOT IN and NOT EXISTS clause in Sybase.
    4) Tell me your approach in terms of performance tuning when volume of data is very high for inserting into new table.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    1) sp_helprotect
    2) union a left and right join e.g.
    Code:
    SELECT * INTO #t1 FROM (SELECT 
    1 ,'a' UNION ALL SELECT
    2 ,'b' UNION ALL SELECT 
    5 ,'e' ) t(id, c1)
    
    SELECT * INTO #t2 FROM (SELECT 
    1 ,'a' UNION ALL SELECT
    3 ,'c' UNION ALL SELECT 
    4 ,'d' ) t(id,c1)
    
    SELECT t1.id, t1.c1, t2.c1
    FROM #t1 t1
    LEFT JOIN #t2 t2
      ON t1.id=t2.id
    UNION ALL 
    SELECT t2.id, t1.c1, t2.c1
    FROM #t1 t1
    RIGHT JOIN #t2 t2
      ON t1.id=t2.id
    WHERE t1.id IS NULL
    ORDER BY id
    
    DROP TABLE #t1
    DROP TABLE #t2
    3) The exists perform a join is generally more efficient
    4) It depends, maybe try parallel inserts to partitioned table

Posting Permissions

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