TechQA.

Question

Spark sql, why fallback to SizeInBytesOnlyStatsPlanVisitor when visitWithCTE in BasicStatsPlanVisitor？

score 12 · Answer 1 · 2024-03-05T09:47:08.107000

0

Answer

12

Views

Spark sql, why fallback to SizeInBytesOnlyStatsPlanVisitor when visitWithCTE in BasicStatsPlanVisitor？

12 views Asked by huxiaoxiang At 05 March 2024 at 09:47

score 254 · Answer 2 · 2021-08-26T13:59:12.973000

Oracle 12.2 - Wrong output in query with NESTED LOOPS and ANTI JOIN

254 views Asked by Roberto Hernandez At 26 August 2021 at 13:59

score 728 · Answer 3 · 2021-06-29T13:40:08.770000

Oracle Query with Cross join - Performance problem

728 views Asked by Roberto Hernandez At 29 June 2021 at 13:40

score 643 · Answer 4 · 2021-06-10T15:53:43.287000

Performance problem with QUERY using BIND variables and OR condition in Oracle 12.2

643 views Asked by Roberto Hernandez At 10 June 2021 at 15:53

score 571 · Answer 5 · 2019-03-18T01:03:17.017000

Can we leverage Spark's CBO (Cost Based Optimizer) with native parquet or in-memory dataframe?

571 views Asked by Simon At 18 March 2019 at 01:03

score 656 · Answer 6 · 2018-05-16T12:42:52.497000

Oracle timestamp with local time zone CBO Format

656 views Asked by T.TAV At 16 May 2018 at 12:42

score 1058 · Answer 7 · 2017-11-08T10:05:26.980000

Optimizing Hive subquery queries

1k views Asked by Subramaniam Ramasubramanian At 08 November 2017 at 10:05

score 735 · Answer 8 · 2017-05-19T05:05:38.247000

Determining the Efferent coupling between objects (CBO Metric) using the parsed byte-code generated by BCEL

735 views Asked by Shehanka Fernando At 19 May 2017 at 05:05

score 2165 · Answer 9 · 2016-03-15T00:26:28.300000

hive: Plan not optimized by CBO

2.1k views Asked by Amit Sharma At 15 March 2016 at 00:26

score 35 · Answer 10 · 2015-08-31T20:16:25.753000

Oracle Optimizer not taking the same plan. SQL Dev vs Application Code

35 views Asked by Tony Schaffert At 31 August 2015 at 20:16

score 1049 · Answer 11 · 2014-09-08T18:42:52.190000

Oracle adding a condition in where clause slows down a query

1k views Asked by user3570198 At 08 September 2014 at 18:42

score 588 · Answer 12 · 2014-02-10T04:43:09.550000

Calculating Efferent Coupling in Java

588 views Asked by Tristan At 10 February 2014 at 04:43

score 576 · Answer 13 · 2012-10-01T21:09:08.567000

Adding 'distinct' keyword to oracle query obliterates query performance for no reason

576 views Asked by Evan Cross At 01 October 2012 at 21:09

score 1072 · Answer 14 · 2011-01-28T19:07:14.357000

Oracle MAX() bug with NULLs CBO index fix leads to index limitation

1k views Asked by AudioBubble At 28 January 2011 at 19:07

score 3517 · Answer 15 · 2009-07-14T02:52:37.800000

How to increase Oracle CBO cost estimation for hash joins, group by's and order by's without hints

3.5k views Asked by Andrew G At 14 July 2009 at 02:52

score 20713 · Answer 16 · 2009-02-26T08:10:00.970000

Tips for improving this slow mysql query?

20.7k views Asked by makeee At 26 February 2009 at 08:10

score 181433 · Answer 17 · 2009-02-25T16:37:23.673000

PostgreSQL - fetch the rows which have the Max value for a column in each GROUP BY group

181.4k views Asked by Joshua Berry At 25 February 2009 at 16:37

TechQA.

List Question

Spark sql, why fallback to SizeInBytesOnlyStatsPlanVisitor when visitWithCTE in BasicStatsPlanVisitor？

Oracle 12.2 - Wrong output in query with NESTED LOOPS and ANTI JOIN

Oracle Query with Cross join - Performance problem

Performance problem with QUERY using BIND variables and OR condition in Oracle 12.2

Can we leverage Spark's CBO (Cost Based Optimizer) with native parquet or in-memory dataframe?

Oracle timestamp with local time zone CBO Format

Optimizing Hive subquery queries

Determining the Efferent coupling between objects (CBO Metric) using the parsed byte-code generated by BCEL

hive: Plan not optimized by CBO

Oracle Optimizer not taking the same plan. SQL Dev vs Application Code

Oracle adding a condition in where clause slows down a query

Calculating Efferent Coupling in Java

Adding 'distinct' keyword to oracle query obliterates query performance for no reason

Oracle MAX() bug with NULLs CBO index fix leads to index limitation

How to increase Oracle CBO cost estimation for hash joins, group by's and order by's without hints

Tips for improving this slow mysql query?

PostgreSQL - fetch the rows which have the Max value for a column in each GROUP BY group

Popular Questions

Popular Tags

Trending Questions