On Wed, Apr 16, 2014 at 1:02 PM, < [email protected]> wrote:
> I've got a very large MariaDB (MySQL) table and ran an EXPLAIN on a GROUP > BY query and a separate DISTINCT query on an indexed field. Both came back > the same in terms of optimization. ymmv. > > ------------------- What was the details on the plan the engine was running? Do you have a join in the tables? Are you looking to limit rows on a column in a joined table? What are the indexes on that table? I have a 600 mill row table, GL Transactions, that will give you the tight set instantly. I am in a joined environment in this situation and this is the child table. In my DW pull when I try to extract only changes done last night it takes 2+ hours to get me the few thousand. Same tables and join, different column for change date. Have been told to NOT tweak index on this to fix it either till our conversion is done. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmylkk5efeljuvh0cp9ugpejb03lruwlt+mznbtyvtpm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
