Optimization of a select query

[Vinod Venugopal]

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

[Greg D. Moore \(Strider\)]

"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

[Ross Presser]

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.