Question

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

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

12

Views

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

Published on 05 March 2024 at 09:47

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

254

Views

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

Published on 26 August 2021 at 13:59

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

728

Views

Oracle Query with Cross join - Performance problem

Published on 29 June 2021 at 13:40

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

643

Views

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

Published on 10 June 2021 at 15:53

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

571

Views

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

Published on 18 March 2019 at 01:03

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

656

Views

Oracle timestamp with local time zone CBO Format

Published on 16 May 2018 at 12:42

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

1k

Views

Optimizing Hive subquery queries

Published on 08 November 2017 at 10:05

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

735

Views

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

Published on 19 May 2017 at 05:05

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

2.1k

Views

hive: Plan not optimized by CBO

Published on 15 March 2016 at 00:26

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

35

Views

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

Published on 31 August 2015 at 20:16

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

1k

Views

Oracle adding a condition in where clause slows down a query

Published on 08 September 2014 at 18:42

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

588

Views

Calculating Efferent Coupling in Java

Published on 10 February 2014 at 04:43

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

576

Views

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

Published on 01 October 2012 at 21:09

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

1k

Views

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

Published on 28 January 2011 at 19:07

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

3.5k

Views

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

Published on 14 July 2009 at 02:52

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

20.7k

Views

Tips for improving this slow mysql query?

Published on 26 February 2009 at 08:10

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

181.4k

Views

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

Published on 25 February 2009 at 16:37

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

Trending Questions

Popular # Hahtags

Popular Questions