How does Oracle do field comparisons with good performance ?
31/12/2017 11:47
Hi, Setting aside indexes, does anyone know how the technical Oracleinternals do row by row, field by field compares of data for a joinbetween 2 tables with decent performance ? Thanks, Jack

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
31/12/2017 11:47 - Yes but the documentation does not explain how the algorithms / lowlevel code works under the hood to actually enable a join to occur..

Can you tell me how it works in detail ? thanks,jack

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
31/12/2017 11:47 - Whatever Jim, you are a real winner, and a heck of a person too.


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
31/12/2017 11:47 - Jack <jack_posemsky@yahoo.com> wrote in messagenews:1142404507.641154.239560@i40g2000cwc.googlegroups.com...

You get upset because you are pointed in the right direction, you give nodetail as to what you are looking for - just a vague Define the universe ingeneral , be specific. kind of question. And yet you want some sort ofmaster's thesis for free. I can read documentation. You can't. If youcould you might have at least asked what book would be best to look infirst. That is a legitimate question, doing your homework for you isn't. Iwould be glad to give you a detailed well written, documented answer to yourquestion provided you meet some basic criteria: 1. What version of Oracle? (5, 6, 7, 8,9, 10)2. Clearer statement of the problem.

3. Payment in advance at $300/hour (US). My initial estimate of time toanswer this question in detail with examples and reference to documentationis 1,000 hours of work. (You are pretty vague as to what the constraintsare.)4. It will make a major difference as to what version of Oracle you areasking about.(first clue that you haven't made any attempt to readdocumentation) You take care.

Jim

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
31/12/2017 11:47 - Jack <jack_posemsky@yahoo.com> wrote in messagenews:1142386479.437384.282530@i40g2000cwc.googlegroups.com...

Have you read the documentation? There is a lot of well organizedinformation in there. What is your business problem that you are trying tosolve or understand?Jim

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
31/12/2017 11:47 - It was a cheap shot at you Jim. The question was totally out of line asthe link Mark provided could be found with two minutes of searching andwhat he was really after is proprietary information that will likelynever be published.


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
31/12/2017 11:47 - Jack <jack_posemsky@yahoo.com> wrote in messagenews:1142398525.601071.252370@i39g2000cwa.googlegroups.com...

toWhat business problem are you trying to solve? There is a ton ofinformation in the documentation. (eg hash joins, nested loops, etc.) Itreally depends. It also depends on what version of Oracle etc. (are thereindexes, are there statistics, etc.) You are asking for a highly detailedquestion and have not given any evidence of even reading the documentation.

This sounds a lot like homework.

Make some efforts first.

Jim

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below