473,508 Members | 2,475 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Indexing on replicated databases

I've got the following replication situation...

A --> B --> C

All data changes, updates and adds go into DB-A. I work with DB-C and
pull all my queries for reporting from that. Would there be any problem
with adding new indexes or different indexes to DB-C than exist in DB-A
or B?

Is there a command/query I can issue to show me the indexed columns for
tables in DB-C (I inherited these DB's so there's still a lot I don't
know about their structure).

Thanks,

Jeff McKeon
IT Manager
Telaurus Communications LLC
jm*****@telaurus.com
(973) 889-8990 ex 209=20

***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privileged. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication, or any of its contents or attachments,
is expressly prohibited. If you have received this communication in
error, please re-send it to the sender and delete the original message,
and any copy of it, from your computer system. Thank You.***
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1514

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1656
by: HumanJHawkins | last post by:
Hi, I am using data from multiple databases and/or queries. It would greatly simplify and speed things up if I could use CONTAINS in processing the results. However, "CONTAINS" requires the data...
3
1631
by: chandra.somesh | last post by:
Hi I am having problem indexing large amount of textual data(in range of 200,000 to 1 million). I tried using map container but the compiler just hanged upon entering the data. On bit of...
4
3477
by: jane | last post by:
HI, I try to create summary table like following: create table summary (a int, b int, c int) (select a.aa, b.bb, b.cc from table_a a ,table_b b where a.key=b.key) data initially deferred...
10
2961
by: Lyle Fairfield | last post by:
By default mdb etc files are not searched by Indexing Service. The default can be changed in Windows XP Pro using Group Policy. I can find no suggested way to make the change in the Windows XO...
4
2053
by: Amar | last post by:
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...
1
1703
by: aine_canby | last post by:
Hi, My company has an old access database which has been in use for many years now by a few employees. I need to make some design changes to one of the forms, but I'm not sure how I should go...
1
1013
by: garrettm | last post by:
I've got 2 SQL server 2000 machined synched up using replication and there are full text catalogs running on 2 of the tables. the tables have the same number of records (as they're replicated) and...
4
2727
by: Bob Alston | last post by:
For those of you that have replicated databases, how often to you compact and repair them? Also what mathod do you use if you do this on an automated way? How do you make sure that the...
2
4551
by: Eric L | last post by:
A client has a split database. However, the frontend is replicated. Since both frontend databases(replicated + DM)are both on same network drive, we would like to remove the replication of the...
3
2594
by: Bob Alston | last post by:
I have a system built using Access replication. After some initial problems dealing with memo fields, it now seems to be working well. I am curious as to how frequently others Compress & Repair...
0
7231
marktang
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,...
0
7336
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7405
jinu1996
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...
1
7066
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...
0
7504
tracyyun
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...
0
5643
agi2029
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,...
0
3198
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
773
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
435
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.