Subscribe

Author Profile

Tom Kyte

In his 22 years at Oracle, Tom Kyte started the Ask Tom question and answer site and was the site's sole proprietor for almost 15 years. In his spare time, he also wrote Expert Oracle Database Architecture (Apress, 2005, 2010, 2014) and Effective Oracle by Design (Oracle Press, 2003), among other books. (The Ask Tom site continues today as Ask TOM: Ask The Oracle Masters.)

On Deferring and Bulking Up

Photography by Aaron Burson, Unsplash Our technologist prefers not to defer and works to increase bulk. By Tom Kyte May/June 2011 In your column “On Constraints,...

On Tuning, Planning, and Contexts

Our technologist tunes data models, plans for partitions, and puts SQL in context. By Tom Kyte March/April 2011 I have a query that is not very complex but is...

On History, Invisibility, and Moving

Our technologist counts on histograms, proves hash tables by example, and moves CLOBs. By Tom Kyte January/February 2011 I have a question about using histograms...

On Consistent Results, Different Constraints, and Unlearning

Our technologist reads as of a consistent point in time, uses the right constraint, and revises old learning on unindexed foreign keys. By Tom Kyte November/Decem...

On Popularity, Learning, and Unlearning

Our technologist revisits a classic, recounts Cardinality Feedback, and remembers SQL*Plus. By Tom Kyte September/October 2010 From time to time, I get e-mails...

On Connecting, Pivoting, and Learning New Things

Our technologist bypasses TNSNAMES.ORA, turns rows to columns, and meets the NO_DATA_NEEDED exception. By Tom Kyte July/August 2010 I am trying to use SQL*Plus to...

Looking at Edition-Based Redefinition, Part 3

Our technologist concludes his exploration of Edition-Based Redefinition. By Tom Kyte May/June 2010 In the last issue of Oracle Magazine (March/April 2010),...

Edition-Based Redefinition, Part 2

Our technologist continues to explore Edition-Based Redefinition, with a full schema change. By Tom Kyte March/April 2010 In the last issue of Oracle Magazine (Jan...

A Closer Look at the New Edition

Our technologist redefines and defers with Oracle Database 11g Release 2. By Tom Kyte January/February 2010 Instead of using the usual question-and-answer format...