Printable View
Hi All.
I am having access table containing 35000 records and 30 columns, when i use query to select one record from that table, query execution takes so much time.
I have created an indexed field . Still execution is slow.
Please tell me where i am wrong ?
Welcome!
First thing, have you backed up and then compacted the database with the table lately? (Be sure to make a backup first!)
Is the database split?
Is there an single index on the fields you are using with the selection criteria?
Can you post the SQL for the query?
Hello.
This is not database split.
I have to select any one of field based on any criteria.
That means if my table is "customer_master" then i require address or city or code or any other information.
But when i give query as "select city from customer_master where id =1 '" then this query takes too much time to execute if there are many records stored in my table. here "id" is my indexed field.
Have you backed up and then compacted the database lately? If not, I would recommend this.
I have compacted my database still its slow.
What version of Access are you using?
Is the database on the local hard drive or on the network?
Do you have a primary key set? Is "id" as the primary key?
Can you post the SQL for the query?
I am using Ms-access 2000.
My database is located on novell server.
My table's "id" fiels is primary key. but i havenot set it as primary key. its an autonumber field.