469,631 Members | 1,776 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Optimization of a select query

Hello Eveybody,

I have just joined as DBA.My problem will be simple for you all
gurus.I have a table with 50 lakh row,when i am writing a select
statement for this table it takes around 7 minute to display result.I
used DBCC REINDEX for this table but it was not effective.
So please pass ur suggestion that i should follw to reduce my
execution time.
As its effecting my server performance.

Thank u in advance
vv
Jul 23 '05 #1
2 1360

"Vinod Venugopal" <vi*************@gmail.com> wrote in message
news:98*************************@posting.google.co m...
Hello Eveybody,

I have just joined as DBA.My problem will be simple for you all
gurus.I have a table with 50 lakh row,when i am writing a select
statement for this table it takes around 7 minute to display result.I
used DBCC REINDEX for this table but it was not effective.
So please pass ur suggestion that i should follw to reduce my
execution time.
As its effecting my server performance.
Without a sample schema and some data folks can play with and examples of
your queries, there's not much people can suggest.

It's not clear, but I'm assuming that you actually have indexes on the
columns in your where clause? If not,the DBCC REINDEX doesn't matter one
way or another.

(also, what's lakh?)


Thank u in advance
vv

Jul 23 '05 #2
On Tue, 12 Apr 2005 13:37:12 GMT, Greg D. Moore (Strider) wrote:
(also, what's lakh?)
http://en.wikipedia.org/wiki/Lakh.
| A lakh (also spelled lac) is a unit in a traditional number system, still
| widely used in India, equal to a hundred thousand. A hundred lakh makes
| a crore.
|
| This system of measurement also introduces separators into numbers in a
| different place than is common outside India. For example, 3 million (30
| lakh) would be written as 30,00,000.

So, when the OP says
I have a table with 50 lakh row


he means five million rows.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bacci | last post: by
3 posts views Thread by Alex Glass | last post: by
6 posts views Thread by Umar Farooq | last post: by
2 posts views Thread by Eugene | last post: by
4 posts views Thread by Bernard Dhooghe | last post: by
3 posts views Thread by Michel Esber | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.