Adding values returned by GREATEST

Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A = 1, B = 3, C=0, D = 0, E = 1 and F = 0 and I run a query: SELECT

Re: Performance boost by splitting up large table?

Hi, You could split the table into two and can avoid code changes by creating a view which matches what code is looking for. I think loading few fields vs 254 into memory will make a difference but if your select statement only have specific fields you want and not the whole row (and also given

Re: Decode Json in MySQL query

probably want to perform this conversion on your client. There are JSON parser libraries available for Java, PHP and the like. Cheers, Karr On Mar 20, 2014, at 11:35 AM, Sukhjinder K. Narula narula...@gmail.com wrote: Hello, I would like to know if there is a way to decode the json

Decode Json in MySQL query

Hello, I would like to know if there is a way to decode the json string stored in one of the fields as text without using triggers or stored procedures. What I want to do is is within the query, I would like to get one row per element within the json string. For example: the json string is as

Re: a Java-connector

Its called JDBC connector, please see the link: http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html good luck. On Wed, Dec 11, 2013 at 10:15 AM, h...@tbbs.net wrote: I have MySQL 5.5.8 under Windows Vista, and I am minded to write Java programs to talk

Re: Check for numeric values

Hi, You could use regular expression to do this, here is the example with the reference site that might help you: If your data is 'test', 'test0', 'test', '111test', '111' SELECT * FROM myTable WHERE col1 REGEXP '^[0-9]+$'; Result: '111' In regex ^ mean begin, and $ - end. SELECT * FROM

Re: Problem with having

Hi, In your second query, you seem to have MIN(date_time), but you are talking about maximum. So your group by query is actually pulling the minimum date for this recipe. Regards. On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell larry.mart...@gmail.comwrote: I want to find the rows from a table

Question regarding creating a query

Hello, I have a question regarding creating a query as follows: I have several databases (all with same structure), which I to query. For instansce: db1, db2, db3 - all have table tb1 with field a, b and table tb2 with fields flag1, flag2 So I want to query and get field a from tb for all

Re: MySQL server has gone away

Hi Aveek, I would like to suggest some points here: You could try increasing the max allowed packets to 128MB. Though you think 16MB is enough, increasing it is not going to affect the server. It is dynamic value, so you could revert back the changes if you feel so. Also make sure log_warnings=2

Re: WHERE does not work on calculated view field

Hi Daniel, Could you check the 'myview' once again? I think you thought to create the view as follows: CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS `TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*; Now your select queries will give results as

Re: Duplicate key name when importing mysql dump file

Hi Jason, You may have to run ANALYZE TABLE.. for the particular table for which you are facing the error. So it'll rebuild the indexes. This would be the best one to save your data. We can use the method which Mr.Isart suggested, but it'll ignore the error and also will lead to data loss.

Re: load data into temporary table

Realise Their Potential. http://studylink.com On Tue, 2009-05-19 at 02:57 +0100, Alex K wrote: Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http

load data into temporary table

Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Happy New Year

* Hi All, New Year's Eve is the perfect time to bid goodbye to the year 2008 and welcome the New Year 2009. It's the time to rock and roll with friends and family Let the New Year brings with it new hopes and new opportunities to explore. ! Wishing you all a happy and a prosperous New Year!

Re: slow in statement?

Hi Ananda, Indexes are present. I'm passing no more 10 values. Alex 2008/11/10 Ananda Kumar [EMAIL PROTECTED]: it should not cause any issues, unless your passing too many values in id in(1,2,...n). Are the indexes present. On 11/10/08, Alex K [EMAIL PROTECTED] wrote: Hello, It seems

slow in statement?

Hello, It seems to me that the statement id in (id1, id2 ... idn) is much slower than id=id1 or id=id2 ... or id=idn or I am doing something wrong? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: slow in statement?

for this sql and also the table structure explain select statement desc table_name On 11/10/08, Alex K [EMAIL PROTECTED] wrote: Hi Ananda, Indexes are present. I'm passing no more 10 values. Alex 2008/11/10 Ananda Kumar [EMAIL PROTECTED]: it should not cause any issues, unless your passing

simple design choice

Hello, I have a table of a 1 million users. I want to add a flag called delete if a user wants to delete his account. Note that this situation does not happen a lot. 1) Should I alter my users table and add a delete flag to the users table. it's easy to update however it uses a lot of

Re: simple design choice

2) is probably cleaner but a hassle as well because one needs to make sure all user_ids are also in this new table. 2008/10/3 Alex K [EMAIL PROTECTED]: Hello, I have a table of a 1 million users. I want to add a flag called delete if a user wants to delete his account. Note

Re: simple design choice

That seems like a nice trick. I suppose the flag would just be an int and not an enum in this case. 2008/10/3 Mr. Shawn H. Corey [EMAIL PROTECTED]: On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote: On Fri, Oct 3, 2008 at 9:49 AM, Alex K [EMAIL PROTECTED] wrote: Hello, I have a table

Re: History of changed rows

Thanks for all of you. I will test the suggestions and then reply. CPK -- Keep your Environment clean and green.

History of changed rows

Hi all. How can we manage the history of changed rows in the database. I have some idea but not yet implemented. By using triggers to make a copy of the row being changed to the another table in the same db. Is there any way to only save the changed fields data and field name? Any other idea?

[Stored Procedure] - Error handling

Hello folks, Any way to retrieve the error code/error number from a stored proc. Scenario -- calling a stored proc from PHP - using mysqli_multi_query() The stored proc has multiple queries. Lets say one of the queries generates an exception. How do I retrieve the error message

UTF-8 sorting

Hi, I am getting a problem while making a sort on any column having character set as UTF-8. The soring from a view or a query through ODBC is very slow. I have data in us-english and marathi languages at a time. Sorting is proper but very time consuming! What to do to solve this problem? Your

backup questions

Hi guys, Is it safe to perform a backup of a database by copying its mysql files if the database is: 1) MyISAM and the database is not being used (mysql server turned off)? 2) InnoDB and and the database is not being used? 3) MyISAM and the database is being used? 4) InnoDB and and the

MySQL database synchronization

I have a problem related with 2 mysql database synchronization. We are using a 256kbps internet at our mfg. site and a 2mbps internet connection at our HO. We are using MySQL5.0.45 for our ERP application. We want to work from both locations at a time through ERP software. For this we are trying

Re: performance of heterogeneous joins

Cool it's good to know thank you. On 25/01/2008, Jay Pipes [EMAIL PROTECTED] wrote: Nope, no difference, AFAIK. Alex K wrote: Any ideas pertaining this newbie question? Thank you so much, Hi Guys, Is there a performance hit when joining across multiple databases as opposed

Re: performance of heterogeneous joins

Any ideas pertaining this newbie question? Thank you so much, Hi Guys, Is there a performance hit when joining across multiple databases as opposed to joining multiples tables in one database? Suppose the same tables are available across all databases. Thank you, Alex -- MySQL

Re: select from otherdb.table question?

are working with. So to answer your question, no, a new connection is not established. Brent On Jan 19, 2008, at 10:19 AM, Alex K wrote: Hi Guys, What does the statement select * from otherdb.table do if I haven't explicitly connected to otherdb previously? I would assume it connects

performance of heterogeneous joins

Hi Guys, Is there a performance hit when joining across multiple databases as opposed to joining multiples tables in one database? Suppose the same tables are available across all databases. Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

select from otherdb.table question?

Hi Guys, What does the statement select * from otherdb.table do if I haven't explicitly connected to otherdb previously? I would assume it connects to otherdb and does the select on table but does it create a new connection each time? Is it as efficient as explicitly connecting to otherdb and

basic style shema question

Hi Guys, Let's suppose I have the following table: create table companies ( id int(11) not null auto_increment primary key, # user's login and password email varchar(100), passwordvarchar(100), # basic information company_name

Re: basic style shema question

Jan 2008, Alex K wrote: To summarize one table vs. many tables with one to one relations? As per usual, it depends on your needs. For most flexibility, and to give the DB the best chance to give the best plan for the possible requests I might make in the future, I generally tend towards

bulk updates/inserts and triggers

Hello, I am facing a problem related with triggers and bulk updates/inserts. I have two tables one is having 'transactions' and another is 'documents'. Each record in transactions table relates with a document by DocId. Foreign keys are created. I have activated triggers for transactions table for

Replication - urgent

Hello All, I set up replication between 2 servers recently. I just need one db to be replicated and the SHOW SLAVE STATUS shows this: Relay_Master_Log_File: gyana01-bin.02 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: tallydb,tallydb Now the problem is that there is

Replication - urgent

Hello All, I need to add a couple of more tables to the list of tables to be replicated from a particular db in the salve my.cnf. Can this be done without restarting the mysql server on the slave? Thanks regards, Ratheesh

Replication - urgent

Hello all, I cannot afford to stop my slave server. I have list of tables of the master that are being replicated on the slave. Now I want to remove a couple of tables from this list without affecting the master and slave. How is this possible? Thanks regards, Ratheesh

[Replication] - load

@all, Currently we run all our complex reporting queries on a different server. We are not using replication though. What we are doing is to restore the backup of the live data every night onto the reporting server. So we are running reports on data that is not real time. And we are OK with

Re: [Replication] - urgent

and has been skipped from the relay log? 4.. How do I know immediately that replication has failed? ( have heard that the enterprise edition has some technique for this )? Thanks regards, Ratheesh - Original Message - From: Jan Kirchhoff [EMAIL PROTECTED] To: Ratheesh K J [EMAIL

MySQL Configuration for a powerful server?

Hello all, What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu) 8 GB RAM machine dedicated for MySQL server only. No other application will run on this machine. the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit machine constraint. So what

[Replication] - urgent

Hello all, I issued a create table statement on the master for a table which was not present on the master but present on the slave. I did this purposely to see the error on slave. I am a newbie to replication. Now when i see SLave status on the slave machine it shows that the SQL Thread has

Storing Devnagari unicode data in MySQL

Namaskar, I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with Microsoft Marathi Indic IME 1 version 5. I am storing data in both languages i.e. Marathi and English. So I changed database character set to 'utf8 -- UTF-8 Unicode' and collation to 'utf8_unicode_ci'. Also I changed the

Re: Storing Devnagari unicode data in MySQL

, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Friday, September 28, 2007 1:55 PM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: Storing Devnagari

data position changes when 'Load Data infile'......

Hi Friend, Today I was testing the command 'Load data infile ...' command ( http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html ) in my system. That time I was surprised when I put select statement in that table. The scenario as follows : In a text file which is to be loaded, I am having

Fwd: more options for MySQL tools by MySQL

Hello all, I want to suggest one thing relating to MySQL Tools for 5.0(Administrator, Query browser etc.) - A new feature can be added to use command line options to synchronize structure and data, data transfer in many formats and scheduling above tasks on windows/linux and other OS. If these

more options for MySQL tools by MySQL

Hello all, I want to suggest one thing relating to MySQL Tools for 5.0(Administrator, Query browser etc.) - A new feature can be added to use command line options to synchronize structure and data, data transfer in many formats and scheduling above tasks on windows/linux and other OS. If these

Re: Synchronizing two MySQL servers over slow network

a big slow down. On 8/25/07, C K [EMAIL PROTECTED] wrote: Hi, I have a problem as below- We have a MySQL server for our ERP database. Now we have to implement the ERP for Head office. HO is away from the current setup and connection between the two is through

Synchronizing two MySQL servers over slow network

Hi, I have a problem as below- We have a MySQL server for our ERP database. Now we have to implement the ERP for Head office. HO is away from the current setup and connection between the two is through VPN at slow speed. How can we synchronize the two MySQL servers? Replication, Cluster, or

Re: Synchronizing two MySQL servers over slow network

on? Is there anyway possible to disable to VPN between the two D.B. servers? Perhaps a firewall in between is in use and you can simply setup access rules for both to talk to each other? The VPN tunnel is most likely a big slow down. On 8/25/07, C K [EMAIL PROTECTED] wrote: Hi, I have a problem

Password storage

Friends, I have one question - How to store passwords in MySQL database table in a secure way so that no one can see the password(understand the password string)? Please help Thanks CPK -- Keep your Environment clean and green.

Re: Password storage

Thanks to all, but the problem is that I am using external programs to insert data and I can't use MySQL functions directly. Can I call/implement such type of functions using MS Access 2003? Thanks CPK The md5 function encrypts the input string. - With Warm Regards, Sudheer. S

Fwd: [commercial] MySQL cluster setup and support

-- Forwarded message -- From: C K [EMAIL PROTECTED] Date: Aug 13, 2007 11:37 AM Subject: [commercial] MySQL cluster setup and support To: [EMAIL PROTECTED] Dear all, we are a medium sized company in India having mfg. facilities about 65 kms. from Pune and Head Office in Pune. We

Re: MySQL database synchronizing from 2 locations

Hello, As per your suggestions I tried to get some correct solution for the problem, but there is a big problem for replication and it is network connection. Though Internet is available to the Mfg. Site, it is not having good speed and continuous. So that replication may not be a good choice. As

calling stored procedure trough ODBC

Hello, I am using MySQL 5.0.17 and MyODBC 3.51.14. I ma using MS Access 2003 as front-end Can I call stored procedures from Access ? how ? Also can we use ODBC driver for calling stored procedures or linking SP to Access? Please help Thanks CPK -- Keep your Environment clean and green.

MySQL database synchronizing from 2 locations

Hello, My client has a mfg. unit at 65 Km from a city in India. He wants to connect to his corporate office in the city. Both offices will use same data and same ERP system. He is using Win 2K3 server and MySQL 5.0.17. Is it possible to make them synchronized at a particular or regular intervals?

Foreign key constraints - Known issues ?

Hello All, I just wanted to know whether there are any known issues in defining and using Foreign key constraints in MySQL 4 and MySQL 5. To be specific, are there any issues on using ON DELETE CASCADE and ON UPDATE CASCADE? Would there be any performance issues when we define Foreign key

User Administration

Today I tried to set few user rights for a user. What I need is- There a database called 'mydb' Two users for Mysql 5 on Win 2003 server. One is root and second is 'systemuser'. 'systemuser' do not have right for anything on Mysql, information_schema, but should have only SELECT, INSERT, UPDATE

Blob data

Hello All, I want a clarification. Whe run a forum wherein people send messages with/without attachments. Attachments may contain images, documents etc.. We are actually storing the attachment in a blob column. Sometimes the attachments are big. And today the table size has grown to 40 GB.

MySQL cluster for windows

I have read some where that MySQL cluster will be available in 5.1 release, will it? Is there some progress in this regard? Thanks CPK -- Keep your Environment clean and green.

row lock

My client got a strange problem today. Mysql returned err no 1205. lock wait timeout exceeded. why? this error occured while updating the record. This error isproduced for a single record. I have checked if that record is in use while updating etc., but this record is not in use. I wait for some

Re: Data security - help required

? - Original Message - From: Chris [EMAIL PROTECTED] To: Ratheesh K J [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, May 15, 2007 2:42 PM Subject: Re: Data security - help required Ratheesh K J wrote: Hello all, I have a requirement of maintaining some secret information

Re: Installing 2nd instance on windows.

Thanks to all for so good responce. Now I will experiment with it and reply earliest. Thanks CPK -- Keep your Environment clean and green.

Re: Installing 2nd instance on windows.

Dear friends, thank you for your response. but the problem is that when I try to install MySQL 5.0 from windows .msi installer on windows XP with MySQL 5.0 already installed, the installer does not shows any option regarding new installation. I can just rapair/remove the installation. Why? As I

Installing 2nd instance on windows.

Is it possible to install more than instances on Linux of MySQL 5.0? I am using WinXP SP 2 and MySQL 5.0.17. Thanks CPK -- Keep your Environment clean and green. -- Keep your Environment clean and green.

Installing 2nd instance on windows.

Is it possible to install more than instances on Linux of MySQL 5.0? I am using WinXP SP 2 and MySQL 5.0.17. Thanks CPK -- Keep your Environment clean and green.

Error with mysqldump

When my server was running MySQL 4.1 I used mysqldump for backup with no errors - Redhat Linux 9. In fact when the server crashed and I had to restore the whole box I used the backups from mysqldump to restore all the databases and tables including the users. However, the server is now running

ODBC connector 3.51/5.0

Dear developers from MySQL, can i know when the MySQL connector/ODBc 5.0 will be released. I am facing few major problems regarding 3.51.12 on windows as application crash and wrong data display. please reply thanks, CPK -- Keep your Environment clean and green.

Re: ODBC connector 3.51/5.0

resolved the problem was to rollback to MyODBC-3.51.06. It resolved the issue. I hope this helps. Ron -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 1:01 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: ODBC connector 3.51/5.0 Dear developers

FW: With Ref to the set autocommit =1

Hi Mark I would appreciate if we can define Under_extreme_conditions as you have mentioned in this link below http://archives.neohapsis.com/archives/mysql/2005-q3/0163.html I would appreciate if you can give us a workaround for this, which can eliminate this set autocommit =1 command being

[urgent] - Problem with index_merge

- Thanks Ratheesh K J

Urgent - MySQL 5 - mysqld using a lot of memory consistently

, Ratheesh K J

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

Arul To: Ratheesh K J Sent: Tuesday, January 23, 2007 11:57 AM Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently you threads connected is 38 but your thread cache has only 8. So please do bump it up. Also generate explain plan on both versions of mysql and provide

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

`FLD_ESCALATED_FLAG` (`FLD_ESCALATED_FLAG`), KEY `FLD_BOUNCED_MAIL_FLAG` (`FLD_BOUNCED_MAIL_FLAG`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - Original Message - From: Alex Arul To: Ratheesh K J Cc: mysql@lists.mysql.com Sent: Tuesday, January 23, 2007 12:20 PM Subject: Re: Urgent

Index_Merge : Very slow

. Previously(MySQL 4.1.11) Explain showed the usage of primary Key as the index. How can this be resolved? Thanks Ratheesh K J

Re: Innodb log sequence error - urgent

as shown in my previous post. But everything seems to be working fine. There have been no problems accessing the data. What I can I possibly do to get everything right. How can I correct the log sequence error? Should the log files of App server be in the DB server? Thanks, Ratheesh K J

Innodb log sequence error - urgent

Hello all, yesterday we seperated our app server and db server. We moved our 70GB of data from our app server to a new DB server. We installed MySQL 4.1.11 on the DB server. Now the following happened. On the DB server the ibdata1 and all the databases are the old ones (which were copied

No of columns in a table

I need information for Maximum no. of columns in a table in MySQL with diff. engines. Where can I get it? Thanks and regards, CPK

MySQL Error for Blobs

I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?.

check bugs.

please check bugs and please give the answer Bug ID=24216 and 24216 CPK

Views accessed as table in MS Access

Hello, I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with Jet 4.0. Currently it is not giving the normal problem of Access while inserting new records (#deleted), but when a View created in database is linked with MS Access it is not giviing correct results. e.g. There are two

Which to download

Hello all, Just wanted to know what is the difference between Red Hat Enterprise Linux 3 RPM (x86) downloads and Linux x86 generic RPM (dynamically linked) downloads Which one should I download for a RHEL 3 system? Thanks, Ratheesh Bhat K J

Re: Which to download

is the difference between the two set of rpms? Where (which system) are the Linux x86 generic RPM (dynamically linked) rpms installed then? Thanks, Ratheesh K J - Original Message - From: Jacques Marneweck [EMAIL PROTECTED] To: Ratheesh K J [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent

SQL Query help

Friends, I am developing a database for accounting software. I have one problem regarding calculation of balances on daily basis for all ledgers. I am using Access 2003 as frontend. While designing I found that maintaining of daily balances is impossible to client's requirements. But as the

Mysql Stat - Help required

) We have the tmp_table_size variable set to 64M. And we saw that there are many temp tables created on disk in about 3 - 5 seconds. How do we analyze the optimum value for the tmp_table_size variable? Thanks, Ratheesh Bhat K J

Re: Mysql Stat - Help required

- From: Chris [EMAIL PROTECTED] To: Ratheesh K J [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, September 27, 2006 12:50 PM Subject: Re: Mysql Stat - Help required Ratheesh K J wrote: Hlo, I got this Stat of MySQL. I want to know is there something to worry about, especially

key_buffer_size - need help

of temporary tables being created in our system. What is an optimal value to the key_buffer_size variable in such a case? Ratheesh Bhat K J

Moving database to another machine

way? Ratheesh Bhat K J

Moving database to another machine

way? Thanks, Ratheesh Bhat K J

How to find the no of Inserts and selects

, so how would I determine this figure? Ratheesh Bhat K J

Re: Seperating Application server and Database server

be hlpful Thanks Ratheesh K J - Original Message - From: Brent Baisley [EMAIL PROTECTED] To: Ratheesh K J [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, August 28, 2006 7:33 PM Subject: Re: Seperating Application server and Database server In addition to what the others told you

Re: Anyone tried solidDB for MySQL?

What is this solidDB? where can i get much info on this?? Thanks, Ratheesh Bhat K J

what should be the value of innodb_flush_log_at_trx_commit

to set this var to 0 or 2? Thanks, Ratheesh Bhat K J

Seperating Application server and Database server

Hello all, Currently our application and MySQL server are on the same machine. When should these be seperated? What are the main reasons that we should be having a seperate DB server? Ratheesh Bhat K J

Query takes different times for execution...

? 1) Also i would like to know something about table caching (what exactly gets cached here?) and its advantages 2) What is an optimal join order. Should it be a smaller result joined with a bigger one or vice-versa, Or how does MySQL do it? Thanks, Ratheesh Bhat K J

Some questions on Storage engine

?) will it be helpful if all the temp tables are created with storage engine :MEMORY Thanks, Ratheesh Bhat K J

Buffer size for innodb tables

are using the same server for Apache and MySQL Ratheesh Bhat K J

Adding index -- Need help

FLD_OWNER_COMPANY_ID int(10) unsigned 0 FLD_FOR_COMPANY_ID int(10) unsigned YES 0 FLD_NO_DIRECT_SUBMISSION_FLAG tinyint(1) YES 0 Thanks, Ratheesh Bhat K J

Cardinality

? I also did an ANALYZE TABLE on TBL_XXX. The result is still the same. Thanks, Ratheesh Bhat K J

Table size??

respectively. The first two of them have more than 70 lakh rows. As a preventive measure what could be the best way to optimize these tables? Thanks, Ratheesh Bhat K J

Another question on Cardinality??

? Looking for a specific answer than a depend on situation kind of an answer. Thanks Ratheesh Bhat K J

  1   2   3   4   >