Apparently while optimizing Drupal 6 performance, I found that somewhere DISTINCT is getting added into VIEWS query without added by any means like VIEWS UI or hook_views_query_alter.
When tested with devel module, found that the SELECT query getting executed have the DISTINCT clause. I am having VIEW displayed in a block shows latest 10 nodes. VIEWS's Live Preview doesn't show any DISTINCT added in SELECT statement, but same query when executed at front end shows DISTINCT in devel query log.
I am not understanding where its getting added? Is there any way to remove ?