Thanks shiming
we have tried this method as u suggested , but creating an index on a 5
million records
take a long time, nearly 4 seconds.
And in our case the Database contain 5 Million to 30 or 50 million
records. so if I try to create additional indices on these tables it takes
too much time.
any other suggestions if u have please.
Best regards,
Manzoor Ilahi
I don't understand. Index creation is a one time deal, it's like tables
(there are temporary indexes though, which are also similar to tables). You
don't have to recreate indexes before queries. It only cost you 4 seconds,
but future queries will be a lot faster. Newly inserted rows will be
automatically indexed. Did you compare the performance before and after the
creation of indexes? In my experience, indexes do improve performance a lot
as long as you've indexed the correct columns, i.e. the columns appearing in
where clause and order by clause.
Best regards,
He Shiming
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
