making better for load (normalization?!)

[asmith]

hey guys,

 

in some book i've get this question, i would really appreciate someone help me with it , i can't get it properly :

 

there's a group of articles table :

 

grouparticle table :

id  title  mother_subject

 

articles table :

 

Id Title             Groupid activated star Date_update       entereddate  

Int Varchar(30) int       tinyint  tinyint timestamp              Datetime

 

 

the question is :

1.what do you suggest for making this query load better or something like that :

2.what indexes you think its better to put?

 

db->sql_query("SELECT articles.* from articles INNER JOIN grouparticle ON articles.groupid=grouparticle.id where (activated > '0' ) and star > 0 and (groupid=$gid or parent=$gid) order by star DESC ");

 

 

 

 

 

[fenway]

Which db version?

Post the EXPLAIN.

[asmith]

it meant i change the query to one without having join.

 

is this right :

SELECT * from articles,grouparticales where articles.groupid=grouparticle.id and activated > '0' ...

 

 

still don't know about the "indexes".

 

 

[fenway]

it meant i change the query to one without having join.

What? Is this a differnet question?  I'm confused.  Why would you want to change it?