Re: Query not fast enough?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Larry (Larry_at_discussions.microsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 08:57:02 -0700

Howdy,

I didn't create the database. There is only one index and that is the
primary key. No triggers. Is there a way to attach table info? I don't see
it as an option. I'll send it to you. The Index Tuning Wizard read 100%
cost on the table only. Every thing else was 0%. Thanks.

"Adam Machanic" wrote:

> Can you post DDL (CREATE TABLE statements, including indexes and
> constraints) and sample rows?
>
>
> "Larry" <Larry@discussions.microsoft.com> wrote in message
> news:9AFBA30B-1DD3-42AC-8B9C-015A833AC932@microsoft.com...
> > Hi Folks,
> >
> > I've got a table that contains 34,480 rows. I set the primary key
> > (clustered index) to an nvarchar field. When I execute the simple query
> > below, the execution time reads 00:00:05. I've done al of the things to
> > optimize the query. A search using the same column is used in a web
> > application. They are concerned about the delay. I can't think of
> anything
> > else to do. Any ideas on this one?
> >
> > select * from tbl_documents
> >
> > Thanks in advance
> > Larry
> >
>
>
>

Relevant Pages

  • Naming conventions for special database objects
    ... I am currently doing a review of my personal database naming ... InsteadOfInsert_Orders for multi-purposed triggers. ... Default constraints ... How to name a primary key if not primary key? ...
    (comp.databases)
  • Re: sql tables
    ... they provide several ways the database ... What's wrong with declaring a primary key? ... I mean precisely that: attach. ... And that makes me sad. ...
    (comp.databases.theory)
  • Re: sql tables
    ... they provide several ways the database ... What's wrong with declaring a primary key? ... I mean precisely that: attach. ... "declare a primary key". ...
    (comp.databases.theory)
  • Re: Query not fast enough?
    ... > I didn't create the database. ... > primary key. ... No triggers. ... Is there a way to attach table info? ...
    (microsoft.public.sqlserver.programming)
  • Re: MS SQL Problem when posting with TAdoQuery
    ... Do you have triggers for this table? ... "Stefan Tchigik" сообщил/сообщила в новостях ... I have primary key in my Detail Table. ... >> record to update in the database. ...
    (borland.public.delphi.database.ado)