regarding data model
HI
i had data containing of following fileds
name,email,gender,interests
name is varchar
email is varchar
gender is number
interests is array of integers
total data is 200 million
and interest 200 million * 200
requirement
count should be with in 3 seconds on gender and interest id
0
Comments
@punnareddy - What exactly are you asking? Can you expand on the "interests" column? What do you mean by an array of INTs? That is, are you talking about an object type or just a string of numbers (i.e. 1, 2, 3) that can be stored in a VARCHAR?
hi jim the interset column contains values like (1,3,6,7,8.......uo to 300 values).if i store it as varchar like query is very slow ,so altrnate way of storing plz suggest me