What is Indexing in mysql and how it will be useful and how we can retrieve database content easily from a database table containing about 5lakhs datas

Hi All,

I need to select data from a database table containing huge amount of
data. Now I am storing data using one primary key and I am just using
simple select statement, and this process gives me the output but it is
taking long to execute the query. As much I had heared I want to use
some indexing or cluster indexing which might help me but I am not so
familiar with these things. So if any one having some solutions to
execute the query in short time period that may help me then please
welcome...

Thanks,
Amar :)

.

Relevant Pages

  • Re: Combining two row into one
    ... So you will have to remove the primary key from the SELECT ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • Re: Combining two row into one
    ... If you have a primary key in the table then you will get multiple rows ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • Re: Combining two row into one
    ... So you will have to remove the primary key from the SELECT ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • Re: Import Automation and...
    ... If there's no existing table, construct and execute a create-table ... query (this is different from a make-table query, ... F2 CHAR CONSTRAINT PrKey PRIMARY KEY, ... construct and execute an append query instead of a make-table query. ...
    (microsoft.public.access.externaldata)
  • Re: What is Indexing in mysql and how it will be useful and how we can retrieve database content eas
    ... Now I am storing data using one primary key and I am just using ... taking long to execute the query. ... some indexing or cluster indexing which might help me but I am not so ...
    (comp.lang.php)