Hi slava, Thanks for reply. I will follow Schema and Indexes and update here.
For create table in Ignite, as mentioned, I am importing table schema from Oracle. Below is the CREATE TABLE DDL in oracle: CREATE TABLE TB_USER( USERNAME VARCHAR2(100) PRIMARY KEY, FIRSTNAME VARCHAR2(100), MIDDLENAME VARCHAR2(100), LASTNAME VARCHAR2(100), EMAILID VARCHAR2(100), PHONENO NUMBER(10), DATEOFBIRTH TIMESTAMP(6), CREATIONDATE TIMESTAMP(6), ENABLED VARCHAR2(1), ACOUNTNOTEXPIRED VARCHAR2(1), CREDENTIALNOTEXPIRED VARCHAR2(1), ACCOUNTNOTLOCKED VARCHAR2(1), EMAILVERIFIED VARCHAR2(1), PHONEVERIFIED VARCHAR2(1), PREFEREDROLE VARCHAR2(100) ); -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
