[black_eagle]

i do not want to see various artists (if possible) when i look under music artist view.

You can turn off seeing artists that are featured artists and not album artists by going to Settings -> Media -> Music -> Show song and album artists and turning that OFF.  Then you will only get album artists in the artist list and any artists that are on a compilation album will not be shown.

Trying to fix it in the tags is really not the way to go, unless your tags are either really messed up so Picard is misidentifying stuff or just plain missing.