Re: Optimizer for Queries on snapshot

From: <paul.baumgartel_at_aya.yale.edu>
Date: Wed, 30 Sep 1998 16:59:17 GMT
Message-ID: <6uto15$qoa$1@nnrp1.dejanews.com>

In article <6uqvc6$cnu$1_at_nnrp1.dejanews.com>, swapn187_at_my-dejanews.com wrote:
[snip]

> Question: When the same query is run on the Production server, I am expecting
> that the cost based analyzer cannot be used as the objects being queried are
> snapshots (not tables) that cannot be analyzed. Can anyone give me
> suggestions/information on forcing the cost-based optimizer to work on
> snapshots ?

You *can* analyze the snapshots, by analyzing the 'SNAP$_' tables that contain the snapshot data. This is the method I use and the CBO works fine.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 30 1998 - 11:59:17 CDT