SQL supports 3-level naming. We do 2 with a warning when calling the 3-level [[database_name '.'] correlation_name '.']column_name
This bug was previously known as tracker item 2981001 at http://sourceforge.net/support/tracker.php?aid=2981001
*** Bug 2854 has been marked as a duplicate of this bug. ***
*** Bug 3062 has been marked as a duplicate of this bug. ***
We are facing performance issue while executing below queries, taking around 45 mins after creating partitions(Merge table concept) and order index.
We are using 100 CPU Cores linux machine and having sufficient memory.
Without applying Merge table concept, query just keep running and not coming out, then we are killing forcibly.
1) SELECT M_key, ID FROM "TABLE_TEST" WHERE ID IN (<50,000 UNIQUE IDS>);
2) SELECT COUNT(*) FROM "TABLE_TEST" WHERE ID IN (<50,000 UNIQUE IDS>);
Table "TABLE_TEST" having 122 million rows and 60 columns(data type INT).
We created 10 partitions using Merge table concept, and applied order index in column ID post partitions.
Column ID used in 'IN' clause is primary key.
Could you please help us in solving this issue ?
Thanks in advance.
Please open a new bug report for a new issue. This has nothing whatsoever to do with three-level naming.