[Solved] What does a dot (.) means after a numeric value in Oracle?
EverSQL Database Performance Knowledge Base
What does a dot (.) means after a numeric value in Oracle?
This is my first time using an ORACLE SQL.
I came across with a query like this :
WHERE COLUMN_A = 1.
AND COLUMN_B <> 0.
Can anyone explain me what does a dot (.) after those integers means? Will it make any difference if I don't put a dot (.)?
Thanks in advance :)
How to optimize this SQL query?
The following recommendations will help you in your SQL tuning process. You'll find 3 sections below:
Description of the steps you can take to speed up the query.
The optimal indexes for this query, which you can copy and create in your database.
An automatically re-written query you can copy and execute in your database.
The optimization process and recommendations:
Avoid Selecting Unnecessary Columns (query line: 2): Avoid selecting all columns with the '*' wildcard, unless you intend to use them all. Selecting redundant columns may result in unnecessary performance degradation.
Create Optimal Indexes (modified query below): The recommended indexes are an integral part of this optimization effort and should be created before testing the execution duration of the optimized query.
Optimal indexes for this query:
CREATE INDEX table_a_idx_column_a_column_b ON TABLE_A (COLUMN_A,COLUMN_B);
The optimized query:
TABLE_A.COLUMN_A = 1.
AND TABLE_A.COLUMN_B <> 0.