is there any way i can make this SQL Statement faster

Question

0.00/5 (No votes)

See more:

SQL

Select itemId,itemName,itemBarcode,created,lastModified from tblItems Where itemId IN (Select itemId from tblRoomItems where roomId IN (Select roomId from tblRoom where officeId="12"));

Posted 11-Apr-13 2:02am

NhlanhlaK

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**AmitGajjar** · Accepted Answer · 2013-04-11T02:11:00

Hi,

Try with joining that may help you,

SQL

Select itm.itemId,itm.itemName,itm.itemBarcode,itm.created,itm.lastModified from tblItems itm tbl
left outer join tlbRoomItems ritm on itm.itemid = ritm.itemid
left outer join tblRoom rm on rm.roomId = ritm.roomid
where
rm.officeId = "12"

Your query may be slightly different. try with above query that may improve performance.

best luck.

arindamrudra · Accepted Answer · 2013-04-11T02:11:00

Solution 2

SQL

SELECT  I.itemId,
        I.itemName,
        I.itemBarcode,
        I.created,
        I.lastModified
FROM    tblItems AS I INNER JOIN tblRoomItems AS RI ON I.itemId = RI.itemId
        INNER JOIN tblRoom AS R ON RI.roomId = R.roomId AND R.officeId='12'

Posted 11-Apr-13 2:11am

arindamrudra

is there any way i can make this SQL Statement faster

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

is there any way i can make this SQL Statement faster

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us