Numbers of rows different in Q.A and in E.M.!!
-
Hello Friends, Recently I came one problem, when i opened Sql Enterprise Manager, on right side of window list of Tables, there when i right click on table and i am getting total number of rows say 5 but when i double click then here i am getting 12 rows!!!!!!!!!!!!!! How That possible????? I checked through Query Analyser also there also i am getting 5 rows!!! Can Any body know this Please Help me out!!!!!!!!! Thanks In Advance Shashank
-
Hello Friends, Recently I came one problem, when i opened Sql Enterprise Manager, on right side of window list of Tables, there when i right click on table and i am getting total number of rows say 5 but when i double click then here i am getting 12 rows!!!!!!!!!!!!!! How That possible????? I checked through Query Analyser also there also i am getting 5 rows!!! Can Any body know this Please Help me out!!!!!!!!! Thanks In Advance Shashank
under2811 wrote: there when i right click on table and i am getting total number of rows say 5 but when i double click then here i am getting 12 rows When I right-click on a table I get a menu. I'm guessing you've missed a step here and selected something from the menu as well.
My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
under2811 wrote: there when i right click on table and i am getting total number of rows say 5 but when i double click then here i am getting 12 rows When I right-click on a table I get a menu. I'm guessing you've missed a step here and selected something from the menu as well.
My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
Hello Colin Angus Mackay, When I right click on table i am getting menus there open table>> Return all rows here i am getting 5 rows while when i double click on table_name there i am getting 12 rows!!! how that is possible????? Thanks In Advance Shashank
-
Hello Colin Angus Mackay, When I right click on table i am getting menus there open table>> Return all rows here i am getting 5 rows while when i double click on table_name there i am getting 12 rows!!! how that is possible????? Thanks In Advance Shashank
I would think that the database statistics are out of date. You could try running UPDATE STATISTICS[^] in the query analyser.
My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
Hello Colin Angus Mackay, When I right click on table i am getting menus there open table>> Return all rows here i am getting 5 rows while when i double click on table_name there i am getting 12 rows!!! how that is possible????? Thanks In Advance Shashank
-
Yulianto. wrote: It's impossible. Actually, it isn't. I've seen the database report in Enterprise Manager so many rows for a table, but if I do a
SELECT COUNT(*) FROM TableNamein the Query Analyser I get a different result. This is because the database statistics haven't been rebuilt recently so some parts of the database are operating on out of date information. This does not affect the results of a query (it will always be accurate based on the current state of the database) however, out of date statistics can slow down the database as the query optimiser may choose an incorrect query plan.
My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
Yulianto. wrote: It's impossible. Actually, it isn't. I've seen the database report in Enterprise Manager so many rows for a table, but if I do a
SELECT COUNT(*) FROM TableNamein the Query Analyser I get a different result. This is because the database statistics haven't been rebuilt recently so some parts of the database are operating on out of date information. This does not affect the results of a query (it will always be accurate based on the current state of the database) however, out of date statistics can slow down the database as the query optimiser may choose an incorrect query plan.
My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More