Welcome Guest, Not a member yet? Register   Sign In
Help with SELECT statement
#11

[eluser]bgreene[/eluser]
single select with join. i rarely use select from where x in (select x from where). if your table is big and a join is slow, check you have an appropriate index on the table eg on downtime table you'd have an index on eventid (key), deviceid and componentid


Messages In This Thread
Help with SELECT statement - by El Forum - 07-27-2009, 09:25 AM
Help with SELECT statement - by El Forum - 07-27-2009, 09:43 AM
Help with SELECT statement - by El Forum - 07-27-2009, 09:47 AM
Help with SELECT statement - by El Forum - 07-27-2009, 11:14 AM
Help with SELECT statement - by El Forum - 07-29-2009, 08:13 AM
Help with SELECT statement - by El Forum - 08-05-2009, 09:07 AM
Help with SELECT statement - by El Forum - 08-05-2009, 09:25 AM
Help with SELECT statement - by El Forum - 08-05-2009, 09:31 AM
Help with SELECT statement - by El Forum - 08-05-2009, 09:59 AM
Help with SELECT statement - by El Forum - 08-05-2009, 10:19 AM
Help with SELECT statement - by El Forum - 08-05-2009, 10:33 AM



Theme © iAndrew 2016 - Forum software by © MyBB