Roteberg
asked on
Optimize mysql Query
Hi All,
How can I make this query better?
Select a.* ,b.resourcetype from filedocuments a, documentcategories b where a.CategoryID = b.id and b.resourcetype = ? and a.ID=? and a.Version = ?;
Your answer to this is very much appreciate.
Thanks!
How can I make this query better?
Select a.* ,b.resourcetype from filedocuments a, documentcategories b where a.CategoryID = b.id and b.resourcetype = ? and a.ID=? and a.Version = ?;
Your answer to this is very much appreciate.
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER