Error with union all and a hint

Hi I have a problem with executing a UNION ALL statment with added hints. I need the hints to be able to use the index. For example: explain SELECT /*+ INDEX(table1 INDEX_TABLE1_COL) */ col1, col2 FROM table1 WHERE col1='123' UNION ALL SELECT /*+ INDEX(table2 INDEX_TABLE2_COL) */ col1, col2 FR

Problems with Phoenix SqlLine loading large amounts of data

Hello Guys I was able to load my large data set (200 G) with phoenix bulk load tool with your help last week. But I am running into other problem running queries on this now using sqlline. All I am trying to do is run a simple count(*) query. Initially I hit timeout issues due to a socketconnec