Re: Time Manipulation In Query
Dear Rick,
1)Ok the Int I will set it now itself.
2)Can I say that data_length and index_length represent the total disk space used by this particular table. So why you comparing buffer_pool_size is to see if the whole table can go into RAM to avoid a lot reading during query am I right? But if there multiple query then does it make different on buffer_pool_size or must I also set other values?
3)If you look at post on November 23, 2011 11:27AM then in the SHOW CREATE TABLE tblGeoFence \G you will find geoFenceString there.
4)Avg_row_length-represent the avg for a row on that table am I right?
5)I run this SELECT AVG( LENGTH( geoFenceString ) )
FROM tblGeoFence and got this result 316.9497, Do you want me to post some sample data for this table?
Subject
Written By
Posted
November 01, 2011 07:35PM
November 21, 2011 11:50PM
November 23, 2011 11:27AM
November 24, 2011 11:39AM
November 24, 2011 12:11PM
November 25, 2011 12:24PM
Re: Time Manipulation In Query
November 26, 2011 01:54AM
November 26, 2011 10:44PM
November 27, 2011 04:15AM
November 28, 2011 11:09AM
November 28, 2011 07:52PM
November 29, 2011 09:02PM
November 30, 2011 07:29AM
November 20, 2011 11:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.