Re: Partitioned View Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Greg Linwood (g_linwoodQhotmail.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 13:27:07 +1000

Hi Babz

If you've already made the decision to insert directly into the base tables,
then you'll likely find PVs ok. They can offer significant improvements to
query performance, especially if the underlying base tables are located on
physically separated disks. The PV can also offer the Query Optimiser an
alternative to performing full table scans in many cases.

Regards,
Greg Linwood
SQL Server MVP

"Babz" <anonymous@discussions.microsoft.com> wrote in message
news:3F05CF94-4299-4E92-85AD-686A171E208B@microsoft.com...
> Hi,
> Thanx a lot friends.
>
> I have given only the sample table in my last post. But in actual
scenario, daily thousands of records will be inserted in the tables. I
thought by using identity column i can simplify my primary key logic.
>
> My question is i have created view similar to partitioned view. I am
inserting directly to the base tables. But while selecting i am using that
view. Is this will help in improving my select queries. Becoz if i am
using the select query with out the view means, i have build the query
string in my sp and execute which is not best practice.
>
> Need Help
>
> Babz
>

Relevant Pages

  • Re: DMX Query response time
    ... but mostly training time rather than query performance. ... inside the SQL server since you're invoking the Analysis Services ...
    (microsoft.public.sqlserver.datamining)
  • Re: query grindingly slow!
    ... query performance when the selection & sort fields you are using are indexed ... If you are basing a query on joined tables, ...
    (microsoft.public.access.queries)
  • Re: Query Retrieval is slow
    ... This query insert data into a temp table. ... >columns being declared with statistics. ... >improve query performance? ... >>sql server indexes automatically and server processor. ...
    (comp.databases.ms-sqlserver)
  • RE: MSDE Performance
    ... MSDE 2000 does not support query parallelism and some other tuning features. ... > I am using MSDE and i recently realised that the query performance is ... > Could it be that MSDE performance is so dramatically lower than SQL Server? ...
    (microsoft.public.sqlserver.msde)