What is the best way to create projections in Vertica?
===

 Hy all <br/>
 I am trying to understand how Vertica DB works.<br/>
I want to know what is the best way to create the projections that will be used by my queries.<br/>
1 -I know i can create by writing the code on the vsql line.<br/>
2 -Provide the query that will be used to the Vertica Database Designer so that Vertica will create the proper projections for itself .<br/>

 I am a bit confused, as i create them by hand(without the Db Designer), but Vertica does not seam to use them.<br/>
 Example :<br/>
- i have table AAA(id, name , address) <br/>
 And i am plannig to make the folowing select on it :<br/>
   select count(name) from AAA;<br/>
-for this i am creating a projection called proj1:<br/>
   create projection  proj1 as select name from AAA ;<br/>
Great now i have my created projection:<br/>but when i run the "explain" form my select count script the plan shows that the created projection is not used !!!????<br/>

 Anybody can explain this better to me then the Vertica docs ?<br/>
THX