Re: Indexing a view

From: Anand <ashrivastava_at_auriga-insys.com>
Date: 12 Sep 2002 02:49:48 -0700
Message-ID: <396cc940.0209120149.2c5f0a9c_at_posting.google.com>

Hi,

Even I have a similar problem. I've a view that is based upon just two tables but has more than 60 fields and approximately 400,000 records. However I can not opt for materialized views. I've already created index on some of the fields that are often accessed. Any other suggestions how can I speed up the performance?

Regards,
Anand Received on Thu Sep 12 2002 - 11:49:48 CEST

This message: [ Message body ]
Next message: Ban Spam: "Re: Indexing a view"
Previous message: Diego F Garcia Barquin: "calling stored procedures via dblink"
Next in thread: Ban Spam: "Re: Indexing a view"
Reply: Ban Spam: "Re: Indexing a view"
Maybe reply: Ognjen Antonic: "Re: Indexing a view"

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

Original text of this message