SQL Server dilemma, performance

Posted by Woland on Stack Overflow See other posts from Stack Overflow or by Woland
Published on 2010-05-04T10:17:21Z Indexed on 2010/05/04 10:48 UTC
Read the original article Hit count: 129

Filed under:
|

Hello

I am creating app where user can save options

witch one is better?

  1. to save into user table varchar feeld smthing like ('1,23,4354,34,3') query for this is select * from data where CHARINDEX ( 'L', Providers , 0 ) > 0

  2. create other table where user options are and just add rows select * from data where Providers in (select Providers from userdata where userid=100)

thanks for help

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql