1344MYSQL IN clause is expensive?

Wednesday, December 9, 2009


I would like to use SELECT * from users where userid IN(SELECT userid
from user_book where availability=1)

In the above subquery, it can return 1000 of records. Whether this
operation is expensive?

Dot Net, VB.NET, C#, ADO.Net, ASP.NET, XML, WML, Ajax, SAP, Ruby, Java, SAP, WAP, WML, PHP, MYSQL, ASP, SQL, HTML, DHTML CSS, Flash, Flex, IT Jobs , Freelancer Projects & many more

Read more.. http://groups.google.com/group/it_help_desk


Post a Comment