* david drummard ([EMAIL PROTECTED]) wrote:
> thanks very much for the response. Are there any special commands to analyze
> the index before using the table. If i rename the table, will the indexes
> still stay with the table ( i hope so).
You want to run 'analyze ' after you've created the inde
hi stephen,
thanks very much for the response. Are there any special commands to
analyze the index before using the table. If i rename the table, will
the indexes still stay with the table ( i hope so).
best regards
vijay erantiOn 2/10/06, Stephen Frost <[EMAIL PROTECTED]> wrote:
* david drummar
* david drummard ([EMAIL PROTECTED]) wrote:
> My question is what is the best way to do step (1) so that after the copy is
> done, the table is fully indexed and properly balanced and optimized for
> query.
> Should i create indexes before or after import ? I need to do this in
> shortest period o
I have an unique requirement. I have a feed of 2.5 - 3 million rows of
data which arrives every 1/2 an hour. Each row has 2 small string
values (about 50 chars each) and 10 int values. I need
searcheability and running arbitrary queries on any of these values.
This means i have to create an index
