I am querying a really big view (more than 100 columns, more than 100 million rows),
when running distinct on one column with restrictions in WHERE clause, it returns 200 rows.
However, when running the same query (same WHERE clause) with "top 10 * " it returns 0 rows.
Any idea? I tried both ODBC and Teradata connectivity. Using SQL Assistant.
version of TD: 14.00.04.04a