AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 51 min 54 sec ago

filtered hierarchical query

Tue, 12/13/2016 - 00:00
I have some hierarchical data (potentially ~80 million rows, if that's important): <code> drop table test; create table test (id number,pid number,t varchar2(20)); insert into test values (1,NULL,'Animalia'); insert into test values (2,1,'Mamm...

Partitioning Strategy

Fri, 12/09/2016 - 00:00
Hi Tom, This is my first time that I'm posting a question to you. I have been huge fan of your answer and humor sometimes :) Keep it up !! Q) I have a schema that contains around 50 tables, 5 tables contain around 1.5 billion rows and rest 45 ...

Index creation taking more time

Wed, 12/07/2016 - 00:00
Hello Tom, The index creation is taking more time. Previously the index creation used to take around 1 min and now it has increased to 10 - 20 min. The indexes are dropped and recreated on a daily basis during our night load. Due to this, our ni...