Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: litenin
  • Content: Threads
  • Order by date
  1. litenin

    Strange Query Optimiser information

    Hello, We have a SQL Server 2000 Instance with two database which are exactly the same, one is a restored backup of the other. One of the tables has about 20000000 rows in it. When we run a query which does a count grouping by one of the indexed columns the restored database uses an index and...
  2. litenin

    'Group by' is painfully slow

    Hi, We have a IDS 7.31 on an 8*731Mhz CPU Alpha. Everything runs quickly until a group by is added to the query. I know you'd expect the query to be slower but, it's about 50-100 times slower than other databases e.g SQL Server and MySQL with the same data and query running on Dual Pentium Pro...

Part and Inventory Search

Back
Top