You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 10-26-2014, 06:26 AM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
How does Join Transitive Closure (JTC) differ from Search Argument (SARG) Transitive
10-02-2009, 02:22 PM
Post: #1
Quote this message in a reply
How does Join Transitive Closure (JTC) differ from Search Argument (SARG) Transitive


How does Join Transitive Closure (JTC) differ from Search Argument (SARG) Transitive Closure in Sybase

To enable systemwide merge joins, use sp_configure as follows:
sp_configure "enable sort-merge join and JTC", 1
Additionally, you can turn JTC on during a session with the set jtc on command.


Find all posts by this user
Post Reply 


Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication