First apologize for the bad English; I am a beginner and I'm having trouble making a COUNT (*) to a table X with 400 million approx. someone could guide me how to do this count with in less time, and do I need for a process within a stored procedure the problem that this count is delaying near 2HR and delay the overall process and 5HR, as this data could take the otherwise table, view materialized ?¿ ...
Welcome to our forum, but note it is intended only for questions regarding the SQL Developer tool. A more appropriate forum may be: SQL and PL/SQL
The trick to navigating to the correct forum is realizing SQL and PL/SQL are database languages rather than application development tools. Look at the Forum Home link at the top of each forum page, click through Forum Home > Database > SQL and PL/SQL to get to the correct forum.