sql

Question

Oracle (SQL plus)

can I use date in create index
example
create index Table_Date_idx on Table(Date);
???

Answer 1

Yes you can according to this post.

Please choosse your indexes wisely. Some post say that other searches are faster and creating a data-index is not speeding up you search.

https://blogs.oracle.com/sql/how-to-create-and-use-indexes-in-oracle-database

https://dba.stackexchange.com/questions/47462/index-for-date-column-for-range-query-in-oracle
create index date_at_midnight_i on table ( trunc ( datetime ) );

Please use proper tags, to support sololearn to find you post fast.
Consider words like
sql Oracle Index