July 29, 2013 at 5:58 am
HI,
Iam migrating code from SYBASE database to SQL 2012. I came across a scenario in SYBASE that I have to deal with a statement
SET TABLE COUNT <some number>
When I checked this in SYBASE infocentre, I came to know that ,this statement tells the query optimizer to use user defined number of tables ,while joining multiple tables. I want to know, is there any command in sql 2012,which is functionally equivalent ?
Thanks
July 29, 2013 at 9:02 am
No, not to my knowledge. See Books Online for various hints that can be used with FROM and JOIN, there are plenty of them (but BEWARE - if you don't know what you are doing you can REALLY FUBAR things!!), just not one to force a specific number of "JOIN-processing" tables.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 30, 2013 at 6:22 pm
If I understand the functionality right I think it's the "force order" hint. But as theSQLGuru said: just use it if you really know what you're doing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply