This week's book giveaway is in the Artificial Intelligence and Machine Learning forum.
We're giving away four copies of TensorFlow 2.0 in Action and have Thushan Ganegedara on-line!
See this thread for details.
Win a copy of TensorFlow 2.0 in Action this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

(SQL Oracle) My query is running slower after implementation of Cluster.

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Everyone!

So I implemented a cluster to optimize one of my queries and it seems to of slowed it down by 3 times its original speed with no optomization.

Here is the query:



Here is the cluster creating code:


Simply
Without optomization I was getting a elapsed time (looking at the trace results) of 0.60. After implementing just indexes (for one example, I did CREATE INDEX id_customer ON CUSTOMER2(custid);) it brought my elapsed time from 0.60 to 0.54 after multiple tests.

So the next step was clusters, yet after following trace results I am now getting 1.50.

I think it has something to do with the way I am setting the size, however I am very new to this so I am unable to spot what I am doing wrong.

Thank you for any help!
 
Dale Viljoen
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The query might not make much sense, but the goal was to make a sub nested unoptimized query so that we can see how much of a difference each optimization makes.
 
We begin by testing your absorbancy by exposing you to this tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic