Hi, My query is select count(*), b from a group by b; Index is created on column 'b' and column 'b' is a timestamp. This query does not use that index.
Speed Oracle SQL with Temporary Tables. For certain types of SQL operations, the creation of intermediate result tables can result in stunning performance improvements
XMLType speed. From: Martic Zoran <zoran_martic@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx; Date: Mon, 24 Jan 2005 01:25:09 -0800 (PST) Hi all, Anybody tried Oracle 10g Beta or has that installed on his system
5. High Scalability - High Scalability - Speed up (Oracle) database ...
Hot Scalability Links For Sep 17, 2010; Strategy: Buy New, Don't Fix the Old; How Can the Large Hadron Collider Withstand One Petabyte of Data a Second?
I must import large *.dmp files with tables to one schema the .Dmp filesize are 21 GB. The Import need 8h to run complete. I use follow option to import:
8. Optimize the Massive DELETE Operation in Oracle, Part 2
Perform the massive DELETE operation as a swap delete with parallel execution. This technique can offer significant performance gains over a straight or in-place delete operation.