{"id":"https://openalex.org/W1601970342","doi":null,"title":"Oracle SQL high-performance tuning","display_name":"Oracle SQL high-performance tuning","publication_year":1997,"publication_date":"1997-01-15","ids":{"openalex":"https://openalex.org/W1601970342","mag":"1601970342"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:781759","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/781759","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5081977331","display_name":"Guy Harrison","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Guy Harrison","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5081977331"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5668,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.72042219,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0008999999845400453,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql-tuning","display_name":"SQL tuning","score":0.7369999885559082},{"id":"https://openalex.org/keywords/oracle-sql","display_name":"Oracle SQL","score":0.718999981880188},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.828000009059906},{"id":"https://openalex.org/keywords/indexing","display_name":"indexing","score":0.6259999871253967},{"id":"https://openalex.org/keywords/b-tree-index","display_name":"B-tree index","score":0.6790000200271606},{"id":"https://openalex.org/keywords/join-optimization","display_name":"join optimization","score":0.6399999856948853},{"id":"https://openalex.org/keywords/parallel-queries","display_name":"parallel queries","score":0.9359999895095825},{"id":"https://openalex.org/keywords/data-model-design","display_name":"data model design","score":0.5289999842643738},{"id":"https://openalex.org/keywords/physical-data-model","display_name":"physical data model","score":0.578000009059906}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8305588364601135},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.8164750337600708},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.8100552558898926},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.7237064838409424},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6786357164382935},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6702458262443542},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.6421329379081726},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.6298199892044067},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6271291375160217},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5680007338523865},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5237890481948853},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.5057520866394043},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.47106000781059265},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.36864984035491943},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2310190498828888},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:cds.cern.ch:781759","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/781759","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:1601970342","doi":null,"is_oa":false,"landing_page_url":"http://ci.nii.ac.jp/ncid/BA42826430","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W203994246","https://openalex.org/W1890845846","https://openalex.org/W4214762111","https://openalex.org/W2516931408","https://openalex.org/W4233100915","https://openalex.org/W2477178274","https://openalex.org/W4312142190","https://openalex.org/W2589808969","https://openalex.org/W4312142172","https://openalex.org/W2026893489"],"abstract_inverted_index":{"(NOTE:":[0],"Each":[1],"chapter":[2],"begins":[3],"with":[4,9,158],"an":[5,138,317],"Introduction":[6,13,21],"and":[7,47,80,120,144,179,207,254,276,307,384],"concludes":[8],"a":[10],"Chapter":[11],"Summary.)":[12],"I.":[14],"THE":[15],"THEORY":[16],"OF":[17],"SQL":[18,23,29,41,61,65,69,101,111,257,302],"TUNING.":[19,303],"1.":[20],"to":[22,53,124,136],"Tuning.":[24],"Why":[25],"Tune":[26],"SQL?":[27],"The":[28,82,270,282,296],"Tuning":[30,114,208,258,311,346],"Process.":[31,315],"2.":[32],"Review":[33,332],"of":[34,37,40,68,78,212,218,249,333,389],"SQL.":[35,38,73,97,221,232,241,244],"History":[36],"Types":[39],"Statements.":[42,193,197],"Query":[43,74,246],"Operations.":[44,182,184,186],"Views.":[45,228],"NULLs":[46],"Three-valued":[48],"Logic.":[49],"Transactions.":[50,199],"Oracle":[51,96,328,335,343,355,372,379],"Extensions":[52],"the":[54,60,104,147,152,171,313,334,338,342,347,390],"ANSI":[55],"Standard.":[56],"Some":[57],"Comments":[58],"on":[59],"Non-Procedural":[62],"Approach.":[63,299],"3.":[64],"Processing.":[66,70],"Overview":[67],"Parsing.":[71],"Executing":[72],"Optimization.":[75],"4.":[76],"Principles":[77],"Indexing":[79],"Clustering.":[81],"B*-Tree":[83],"Index.":[84,392],"Index":[85,91,121,129,159,274],"Clusters.":[86,88,160],"Hash":[87],"Bitmapped":[89],"Indexes.":[90,266],"Only":[92],"Tables.":[93],"5.":[94],"Tracing":[95],"EXPLAIN":[98],"PLAN.":[99],"Using":[100,103,134,206,229,234,264],"Trace.":[102],"AUTOTRACE":[105],"Facility":[106],"in":[107,216],"SQL*PLUS.":[108],"II.":[109],"PRACTICAL":[110],"TUNING":[112],"6.":[113],"Table":[115,118,126,132],"Access.":[116],"Full":[117,125],"Scans":[119],"Lookups.":[122,130],"Alternatives":[123],"Scans.":[127,133],"Optimizing":[128,131,142,156,177,190,194,198,222,227],"Hints":[135],"Influence":[137],"Access":[139],"Path.":[140],"7.":[141],"Joins":[143,157],"Subqueries.":[145,168,175],"Choosing":[146,151],"Best":[148,153],"Join":[149,154],"Method.":[150],"Order.":[155],"Outer":[161],"Joins.":[162,164],"Star":[163],"Hierarchical":[165],"Queries.":[166,251],"Simple":[167],"Subqueries":[169],"Involving":[170],"IN":[172],"Operator.":[173],"Correlated":[174],"8.":[176],"Sorting":[178],"Grouping.":[180],"Sort":[181],"Aggregate":[183],"Set":[185],"Intersect.":[187],"Minus.":[188],"9.":[189],"Data":[191,236,305,320],"Manipulation":[192],"Individual":[195],"DML":[196,201],"Other":[200],"Performance":[202,210],"Issues.":[203],"Locking.":[204],"10.":[205],"PL/SQL.":[209,213,223],"Characteristics":[211],"USING":[214],"PL/SQL":[215],"Place":[217],"StandardA":[219],"A":[289,326,331,359],"11.":[224],"Miscellaneous":[225],"Topics.":[226],"Snapshots.":[230],"Distributed":[231],"Sequences.":[233],"Decode.":[235],"Definition":[237],"Language.":[238],"12.":[239],"Parallel":[240,243,245,250,252],"Understanding":[242],"Option.":[247],"Examples":[248],"DDL":[253],"DML.":[255],"13.":[256],"Case":[259,261,267,279,286,293],"Studies.":[260],"Study":[262,268,280,287,294],"1:":[263],"Concatenated":[265],"2:":[269],"Rule":[271],"Based":[272],"Optimizer,":[273],"Merges":[275],"Bind":[277],"Variables.":[278],"3:":[281],"Slowly":[283],"Degrading":[284],"Query.":[285],"4:":[288],"Number":[290],"Range":[291],"Lookup.":[292],"5:":[295],"First":[297],"Rows":[298],"III.":[300],"BEYOND":[301],"14.":[304],"Model":[306],"Application":[308,322],"Design.":[309,323],"Building":[310,325,341],"into":[312],"Design":[314],"Designing":[316],"Efficient":[318],"Physical":[319],"Model.":[321],"15.":[324],"High-Performance":[327],"Database":[329,348,356],"Server.":[330,349],"Architecture.":[336],"Sizing":[337],"Host":[339],"Computer.":[340],"Database.":[344],"16.":[345],"Evaluating":[350],"Operating":[351],"System":[352],"Performance.":[353],"Recognizing":[354],"Bottlenecks.":[357],"Appendix":[358,362,365,370,375,381,386],":":[360],"Reference.":[361],"B:":[363],"Glossary.":[364],"C:":[366],"Configuring":[367],"Development":[368],"Tools.":[369],"D:":[371],"Server":[373],"Configuration.":[374],"E:":[376],"Differences":[377],"Between":[378],"Versions.":[380],"F:":[382],"Bibliography":[383],"Resources.":[385],"G:":[387],"Contents":[388],"CD-ROM.":[391]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}