Re: Improving performance of full table scans

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 11 Sep 2006 22:21:31 +0200
Message-ID: <4505c54b$0$31470$ba620e4c@news.skynet.be>

"anish" <anish.kanti.ghosh_at_gmail.com> wrote in message news:1157960577.145626.140450_at_q16g2000cwq.googlegroups.com...
> Hi all,
>
> Can anyone help me in the ways for imporving the performance of full
> table scans without additional hardware.
>
> Anish
>

Have you considered using PARALLEL query ? How many CPU's does the server have ?

Matthias Received on Mon Sep 11 2006 - 15:21:31 CDT

This message: [ Message body ]
Next message: dbaplusplus_at_hotmail.com: "Re: Advanced Security"
Previous message: Evan: "Advanced Security"
In reply to: anish: "Improving performance of full table scans"
Next in thread: joel garry: "Re: Improving performance of full table scans"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US