I have a table with more than 100 Mio datasets and I will taste my select. I surch for an command that execute my select and when "Teradata SQL Assistant" find 100 random rows, the select command musst stop at that moment, so I must not wait for an half houre.
select time_id, ekp_no, kpi_id, base_quantity, current_day, count_in_time from vw_customer_b2b_report stop after 100 rows (not FullTableScan)
Is there a command or SQL-command in teradata?? Thanks for your help