python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sqlperformance

Is there any performance loss when using ANSI data types in Oracle?

If I use any ANSI supported data types like INTEGER, NUMERIC, REAL etc., as a data type for a column, or a variable in PL/SQL, will it have an additional cost for the database? What are the pros and c...
test-img

oramas

oracle

query-optimization

database-performance

database-administration

sqlperformance

Votes: 0

Answers: 1

Latest Answer

ANSI data-types are just aliases for Oracle data types and will be converted to the equivalent Oracle data type. From the documentation: ANSI, DB2, and SQL/DS Data Types SQL statements that create ta...
test-img

MT0

Execution time of multiple requests (100+)

I'm looking for the time of execution of a pack of 552 SQL requests on MySQL. I want one execution time for the 552 requests (or the sum of 552 execution times). Ideally, what I need is an SQL request...
test-img

John-Deluxe

mysql

sql

sqlperformance

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs