Answer Posted / prabhudatta barick
Please ignore my first answer...
as By default this job runs within a maintenance windows
between 10 P.M. to 6 A.M. week nights and all day on
weekends.
to get the exact record please use this
ANALYZE TABLE <table_name> COMPUTE STATISTICS;
SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is offset-fetch filter in tsql? : Transact sql
Is it possible to include an insert statement on the same table to which the trigger is assigned?
what is a control file ? : Sql dba
Which table is left in join?
How do I install sql?
Explain what is table in a database?
how to use like conditions? : Sql dba
Can a view be mutating? If yes, then how?
What is ttitle and btitle?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is loop in pl sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Which is faster union or join?
What is auto increment in sql?
Explain normalization and what are the advantages of it?