Home » RDBMS Server » Server Administration » SQL performance for generic queries
SQL performance for generic queries [message #371804] Fri, 08 December 2000 04:05
JOHN
Messages: 182
Registered: April 1998
Senior Member
I'm looking to upgrade performance forqueries that are not aware of the contents of the tables they are querying

I mean i can get the indexes, statistics but I won't know if it will give me 100 or 1 000 000 rows

So it's hard to use classic optimization rules.

I'd like to know which way i can get good performance
(it's a bit like the Oracle optimizer)

Report message to a moderator

Previous Topic: PRIMARY KEY and performance
Next Topic: adding duplicate records in plsql procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 06:21:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.