{"id":"https://openalex.org/W23253958","doi":null,"title":"Oracle SQL Tuning Pocket Reference","display_name":"Oracle SQL Tuning Pocket Reference","alternate_titles":[],"publication_year":2002,"publication_date":"2002-01-01","ids":{"openalex":"https://openalex.org/W23253958","mag":"23253958"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:781758","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/781758","pdf_url":null,"source":{"id":"https://openalex.org/S4306400735","display_name":"International Linear Collider","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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},"parent_works":[],"lineage":["https://openalex.org/W23253958"],"child_works_count":0,"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/A5033679271","display_name":"Mark Gurry","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mark Gurry","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5021640509","display_name":"Jonathan Gennick","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jonathan Gennick","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.5129,"has_fulltext":false,"cited_by_count":7,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.90540078,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":92,"max":95},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9961000084877014,"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.9961000084877014,"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.0006000000284984708,"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/T12127","display_name":"Software System Performance and Reliability","score":0.0005000000237487257,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9139999747276306},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.7300000190734863},{"id":"https://openalex.org/keywords/database-performance","display_name":"database performance","score":0.8659999966621399},{"id":"https://openalex.org/keywords/query-execution-efficiency","display_name":"query execution efficiency","score":0.7390000224113464},{"id":"https://openalex.org/keywords/response-time","display_name":"response time","score":0.7480000257492065},{"id":"https://openalex.org/keywords/database-administration","display_name":"database administration","score":0.5950000286102295},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.3959999978542328}],"concepts":[{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.9132176637649536},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.8764057755470276},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8581472635269165},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7879380583763123},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.7102062702178955},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.638711154460907},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6324965357780457},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.597740888595581},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.564470112323761},{"id":"https://openalex.org/C2777026412","wikidata":"https://www.wikidata.org/wiki/Q2684591","display_name":"Statement (logic)","level":2,"score":0.558444082736969},{"id":"https://openalex.org/C2987003710","wikidata":"https://www.wikidata.org/wiki/Q185524","display_name":"Oracle database","level":3,"score":0.5417793989181519},{"id":"https://openalex.org/C22664368","wikidata":"https://www.wikidata.org/wiki/Q4045949","display_name":"Oracle Unified Method","level":5,"score":0.492752343416214},{"id":"https://openalex.org/C2777138346","wikidata":"https://www.wikidata.org/wiki/Q1714153","display_name":"Performance tuning","level":2,"score":0.49178412556648254},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4407600164413452},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.36688232421875},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.35220855474472046},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.2569199204444885},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.219904363155365},{"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},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:cds.cern.ch:781758","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/781758","pdf_url":null,"source":{"id":"https://openalex.org/S4306400735","display_name":"International Linear Collider","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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:23253958","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/Oracle-SQL-Tuning-Pocket-Reference/dp/0596002688","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":[{"id":"https://openalex.org/G1093960025","display_name":"Clinical Evaluation and Treatment Center for BPH","funder_award_id":"U01DK063825","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G1469710266","display_name":"Continuing Application for the Data Coordinating Center for (CAMUS) Trial (U01)","funder_award_id":"U01DK063788","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G1973679151","display_name":"Complementary and Alternative Medicine for Urological Symptoms (CAMUS)","funder_award_id":"U01DK063795","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G2338191338","display_name":"Saw palmetto and Pygeum africanum on BPH Progression","funder_award_id":"U01DK063866","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G2430458931","display_name":"Alternate Therapies for Benign Prostate Symptoms","funder_award_id":"U01DK063835","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G3151872744","display_name":"Phytotherapy of Prostateic Symptoms (POPW)","funder_award_id":"U01DK063833","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G3745863439","display_name":"CAMUS-Complimentary and Alternative Medicine for Urological Symptoms","funder_award_id":"U01DK063862","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G5244481550","display_name":"Alternative Therapies for BPH, Multiethnic Variability","funder_award_id":"U01DK063831","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G7207342877","display_name":"Alternative Therapies for Benign Prostate Symptoms","funder_award_id":"U01DK063883","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G7773240828","display_name":"Alternative Therapies for Benign Prostate Symptoms","funder_award_id":"U01DK063840","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G7937056126","display_name":"Alternative Therapies for Benign Prostatic Symptoms","funder_award_id":"U01DK063778","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G981247856","display_name":"Alternative Therapies for Benign Prostatic Hyperplasia (CAMUS)","funder_award_id":"U01DK063797","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"}],"funders":[{"id":"https://openalex.org/F4320337357","display_name":"National Institute of Diabetes and Digestive and Kidney Diseases","ror":"https://ror.org/00adh9b73"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":1,"referenced_works":["https://openalex.org/W2099778808"],"related_works":["https://openalex.org/W2993335843","https://openalex.org/W4214762111","https://openalex.org/W2365993797","https://openalex.org/W4233100915","https://openalex.org/W7000518159","https://openalex.org/W145345560","https://openalex.org/W2485723069","https://openalex.org/W203994246","https://openalex.org/W1480705051","https://openalex.org/W2484336995"],"abstract_inverted_index":{"One":[0],"of":[1,32,36],"the":[2,15,33],"most":[3],"important":[4],"challenges":[5],"faced":[6],"by":[7],"Oracle":[8,12],"database":[9,38],"administrators":[10],"and":[11,40,54],"developers":[13],"is":[14],"need":[16],"to":[17],"tune":[18],"SQL":[19,28,44],"statements":[20,29,45],"so":[21],"that":[22,46],"they":[23],"execute":[24],"efficiently.":[25],"Poorly":[26],"tuned":[27],"are":[30],"one":[31],"leading":[34],"causes":[35],"substandard":[37],"performance":[39],"poor":[41],"response":[42],"time.":[43],"perform":[47],"poorly":[48],"result":[49],"in":[50,64],"frustration":[51],"for":[52],"users,":[53],"can":[55],"even":[56],"prevent":[57],"a":[58,65],"company":[59],"from":[60],"serving":[61],"its":[62],"customers":[63],"timely":[66],"manner":[67]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W23253958","counts_by_year":[{"year":2014,"cited_by_count":2}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}
