Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do u count no of rows in a table?

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


Please Help Members By Posting Answers For Below Questions

what is offset-fetch filter in tsql? : Transact sql

943


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1011


what is a control file ? : Sql dba

1032


Which table is left in join?

974


How do I install sql?

986


Explain what is table in a database?

1055


how to use like conditions? : Sql dba

1103


Can a view be mutating? If yes, then how?

1024


What is ttitle and btitle?

1061


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

997


What is loop in pl sql?

1035


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564


Which is faster union or join?

964


What is auto increment in sql?

1115


Explain normalization and what are the advantages of it?

948