Re: Rebuild of indexes and 'Sweeper' referred in Ask tom site

Maxim Demenko wrote:
Robert Klemme schrieb:
On 29.11.2007 16:25, hpuxrac wrote:
On Nov 29, 9:35 am, nirav <shiva...@xxxxxxxxx> wrote:
Hi ,
> There is also a nice paper about index rebuilding myths debunked. I
can't seem to find it right now but as far as I remember Richard Foote was the author and he posted the reference here himself. Very worth the read!

Cheers

robert

It is currently hosted by miracleas
http://www.miracleas.dk/index.asp?page=169&page2=276&page3=179

Best regards

Maxim

Richard was at the OOW Unconference and delivered a number of
presentations on indexing that were the best attended part.

He will be here in Seattle in July of '08 for OracleDays presenting
a full class on the topic: http://www.oracledays.com/
Of course Tom Kyte and Jonathan Lewis will also be attending but
who's counting.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: Oracle Text and searches across columns
    ... I haven't seen an Oracle Text example that handles this type of case. ... with a PL/SQL procedure that will aggregate all this data into a CLOB ... and present that to Oracle Text for indexing. ... DBMS_LOB.WRITEAPPEND(C, LENGTH(sBuf), sBuf); ...
    (comp.databases.oracle.server)
  • Re: Basic INDEX and SELECT questions
    ... Assuming a vanilla situation (no weird requirements, ... modern versions of Oracle) it is maybe better to use A,B,C given ... conditions and you'd have to evaluate each situation on its merits. ... There are none when it comes to indexing in a RDBMS: ...
    (comp.databases.oracle.server)
  • Re: H-50 Running in 64 Bit & Oracle 9.2
    ... According to Oracle's Certification Matrix, ... Regards, ... H-50 Running in 64 Bit & Oracle 9.2 ... does anyone know if running AIX 5.2 in 64bit will allow ...
    (AIX-L)
  • Re: Simple Oracle Query Taking Too Long
    ... I did not feel that the number of rows or indexing was important just the ... process that I was performing. ... indexing and selecting where rownum = 1, ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.misc)
  • Re: Error messageORA-00979: not GROUP BY expression
    ... > I'm writing an application on a Oracle 8 database in combi with the ... The OLE DB provider is Microsoft for Oracle. ... > When I replace manually the parameter:BU to a string in the sql statement ...
    (borland.public.delphi.database.ado)