Ok. I will split my main table of sales. I will work with a daily table,
which contains memo field. But some of my relation tables (e.g. products)
have many records (75000). Also, there is a lot of criteria in the where
clause of my query (e.g. range of dates, an unlimited choice of products numbers, departments, salors and more). I mean the query can be very big.
Do you think a single SELECT SQL with many relations and many criteria
could be used? And how can I use Rushmore or Index with my SELECT SQL?
Thank you!