Re: What makes SQL server to use index ?

From: Krzysztof Krawczyk (kt_AT_swissoft_DOT_wroc_DOT_pl)
Date: 05/10/04 

Date: Mon, 10 May 2004 10:21:49 +0200

Hello,

thank you all for hints. I have tried it all
- recompile SP
- rebuild indexes
- update statistics
without any success. For now I just think that SQL server have different
optimizations results when is installed on Server family OS and on
Professional (client) family OS.

Kind regards,
Krzysztof Krawczyk

"Gert-Jan Strik" <sorry@toomuchspamalready.nl> wrote in message
news:4099417E.260888E4@toomuchspamalready.nl...
> Krzysztof,
>
> make sure the statistics on the second server are up to date. You could
> try running UPDATE STATISTICS just to make sure.
>
> Under normal circumstances, there is no need to hint SQL-Server to use
> an index, because of the cost based optimizer which will always choose
> the plan that is estimated to be the fastest.
>
> Hope this helps,
> Gert-Jan
>
>
> Krzysztof Trawka wrote:
> >
> > Hello Everybody,
> >
> > here is my problem: I have a backup of database from customer. When I
> > restore it on SRV01 (Windows 2000 Server, MS SQL Server 2000) the stored
> > procedure PRC01 runs quite fast (1 sec). But if I restore the same
backup on
> > my machine CLI01 (Windows 2000 Professional, MS SQL Server 2000) or
other
> > CLI02 (Windows XP Professional, MS SQL Server 2000) the same stored
> > procedure PRC01 takes 1,5 min.
> > I have run this procedure using Query Analyser locally and tested the
> > execution plan. Only difference is that PRC01 uses index IDX01 when run
on
> > SRV01 and do not use it when run on CLI01 or CLI02. Other indexes are
used
> > on SRV01, CLI01, CLI02 without a problem.
> >
> > So my question is: what could be reason for this ?
> > Is there any configuration option which could affect this ?
> >
> > Kind regards,
> > Krzysztof Krawczyk
>
> --
> (Please reply only to the newsgroup)

Relevant Pages

  • Re: Update Statistics and poor performance
    ... Is it possible that most sql's run efficiently during update stats ... 9.30UC2 is the last version released before the update statistics code was rewritten in 9.30xC3. ... For your server version you can enable this updated algorithm in dostats by adding the -o flag which inverts the server version detection logic. ... particularly odd looking query. ...
    (comp.databases.informix)
  • Re: Server setup
    ... Just "UPDATE STATISTICS" will work, ... Are you backing up the log files? ... >> Which service pack for Win2K? ... I will have to log into the server to find the Windows ...
    (comp.databases.informix)
  • RE: 2005 JDBC Driver against 2000 Server cant "UPDATE STATISTICS tabl
    ... 2005 JDBC Driver against 2000 Server can't "UPDATE STATISTICS tabl ... Using the latest 2005 sqlserver jdbc driver against a 2000 SQL Server, ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Server setup
    ... GB of RAM running Windows 2000). ... the Informix server seems to crap out and about once a week the database service stops running and cannot be restarted. ... These come from a data file that is parsed (two large downloads a day, ... When do you run UPDATE STATISTICS? ...
    (comp.databases.informix)
Quantcast