Greetings,
MS Access newbie here. Created a table with 7 fields but as it got
more populated, the SEARCH process became slower. I know that indexes
are a solution, so I set one field as INDEXed. I, however, don't know
how to search for a specific record now that I have an INDEXed field.
How can I do it?. What is the most efficient way to do it?
Txs much in advance, sorry about the stupid question! :-(
Randy rc*********@hotmail.com 3 1519
On 10 Nov 2003 19:25:34 -0800, rc*********@hotmail.com (Randy) wrote:
There are many ways you can search a record. Which one are you using?
With most ways, Access automatically uses the index. That is part of
the smarts of the query analyzer, whose job it is to come up with the
fastest way to answer a given question.
-Tom. Greetings, MS Access newbie here. Created a table with 7 fields but as it got more populated, the SEARCH process became slower. I know that indexes are a solution, so I set one field as INDEXed. I, however, don't know how to search for a specific record now that I have an INDEXed field. How can I do it?. What is the most efficient way to do it? Txs much in advance, sorry about the stupid question! :-( Randy rc*********@hotmail.com
Hi Tom,
Txs for your reply!.
I use the "Search" option available through the Edit menu. Assume this
is a sequential search, which becomes slower as the Table grows in
size.
Best,
Randy.
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<98********************************@4ax.com>. .. On 10 Nov 2003 19:25:34 -0800, rc*********@hotmail.com (Randy) wrote:
There are many ways you can search a record. Which one are you using?
With most ways, Access automatically uses the index. That is part of the smarts of the query analyzer, whose job it is to come up with the fastest way to answer a given question.
-Tom. Greetings, MS Access newbie here. Created a table with 7 fields but as it got more populated, the SEARCH process became slower. I know that indexes are a solution, so I set one field as INDEXed. I, however, don't know how to search for a specific record now that I have an INDEXed field. How can I do it?. What is the most efficient way to do it? Txs much in advance, sorry about the stupid question! :-( Randy rc*********@hotmail.com
Sorry, it´s not the "Search" option but the "Find" command available
through the EDIT menu. That's what I use to search for info on my
Tables.
R. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: tracy |
last post by:
Hi,
I need help urgently. Yesterday i move a tables and indexes to
different tablespace using these command:
alter table my_table move tablespace xyz;
alter index my_index rebuild tablespace xyz;...
|
by: Gregory.Spencer |
last post by:
Hi there,
Using PHPMyAdmin and it is very usefully reporting problems with my
MySQL DB.
"PRIMARY and INDEX keys should not both be set for column
`column_name`"
and
|
by: trint |
last post by:
Ok,
This script is something I wrote for bringing up a report in reporting
services and it is really slow...Is their any problems with it or is
their better syntax to speed it up and still provide...
|
by: g_chime |
last post by:
I have a large table (~200 columns, ~10 million rows) and I am trying
to query by two float rows, say f1 and f2:
SELECT... FROM large_table WHERE f1 BETWEEN 10.82 AND 113.998 AND f2
BETWEEN...
|
by: Xu, Wei |
last post by:
Hi,
I have wrote the following sql sentence.Do you have comments to improve
the performance.I have created all the indexed. But it's still very
slow.Thanks
The primary key is proj_ID and...
| |
by: Jeff |
last post by:
This is the first time that I remember ever having too many indexes on a
table, but it has happened.
I have en employees table and store in many places, on tables, the id of the
employee that...
|
by: lesperancer |
last post by:
you start with a small application in access97, then you have more
modules and more...
and you reach the point where tables like 'item' and 'employee' reach
the limit and you
know there's more...
|
by: pootlecat |
last post by:
Hello everyone,
I have a fair sized table now (1,955,041 rows) and it currently has two indexes:
PRIMARY is the ID number
and
Keywords is a FULLTEXT index of the Keywords column (Text).
...
|
by: MMcCarthy |
last post by:
The more data you include in your tables the more you will need to have indexes to search and sort that data. However, there is a balance between having enough indexes and too many. Too many...
|
by: Okonita via DBMonster.com |
last post by:
Hi all,
I am comming along with all this Linus/DB2/scripting business...I am no
longer scared of it!! (LOL). But,
I need to create a .ksh script that does a REORGCHK and output only tables...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |